From everything I can tell, yes and yes. Is there a way to split it after ctrl-enter?

The example of the address is exactly how they are entered, with the exception of the comma after the street address.
Example:
1234 Orange St. New Haven, CT 06511

The person who enters these usually presses Ctrl-Enter after the street address so that when you're looking at the form, it's formatted like this:
1234 Orange St
New Haven, CT 06511

So, in order to split them I would need to add a comma...

Hello -

First off, I'm fairly new with using Access. I have a text field that contains a full address and I would like to split that field into 4 parts - street address, town, state, & zip. I can figure out how to split off the zip & state but I cannot figure out how to split street address from town, as many of the towns contain 2 words. I am working on Access 2000. Can anyone offer me some insight on how to do this? ...