I’ve built a website which pulls information off of several tables in a MS Access database. I have an edit form, update page, then a display page. The edit form will only show what is before a space, even though all the information is showing on the display page.

For example: 4564 Harrison Blvd, will only show 4564 in the edit form but the entire address shows in the display page.

Any ideas why?

Thanks