Simple Address Parse Memo Field

[cache rules]

Hi All, been all over looking for a solution to take a standard US City
mailing address (if there really is such a thing), split it into
strings, then append them to a table. I've seen some code that looks
like it might work sorta because it uses chr(13) and chr(10) as the
delimiter criteria. I also found a piece that might handle the City,
State, ZIP ok because it is comma delimited. My issue is that I do not
yet have the skills to combine them fearing running two queries may
'mis-align' the data in the table.
Here's what I have. A form with CustomerID and ten text boxes(memo
fields) that will allow up to a four line address block to be pasted
from many places. I have a small office so user intervention is not a
real issue to make sure the address is standardized to the table. I've
also created a legend on the form with an example of a "standard"
address.
After the user enters or pastes the addess(es) they will click a
cmdButton to evoke the queries or function in VBA.
Here's what I need:

txtAddress1
ABC Company
Jane Jones
123 Main Street
Anyplace, NY 10022 ----->Move to appropriate fields in [Address] table.

The purpose is to facilitate 'block' pasting vs. entering as this info
may come form web sites, Word docs, e-mails, ect. and these are
possible addresses that may not become a permanant record. I am also
aware of the potential manual clean-up that may be needed after the
append. No prob. Lastly I need to handle Null's because all boxes might
not have been used. I think a Loop function will also be needed.

Pretty desperate at this point so any help (or hopefully an existing
procedure) would be immensely appreciated.
Thanks in advance!

Victor

 

[pietlinden]

Here's what I have. A form with CustomerID and ten text boxes(memo
fields) that will allow up to a four line address block to be pasted
from many places. I have a small office so user intervention is not a
real issue to make sure the address is standardized to the table. I've
also created a legend on the form with an example of a "standard"
address.
After the user enters or pastes the addess(es) they will click a
cmdButton to evoke the queries or function in VBA.
Here's what I need:

you mean you _allow_ your users to completely screw up the data and
then you try to clean it up? Why not just keep them from screwing it
up in the first place? about your best bet is to use regular
expressions and string parsing functions to break it up.

 

[cache rules]

This is not at all what I am doing but I knew I would get answers like
this.

-you mean you _allow_ your users to completely screw up the data and
then you try to clean it up?

On the main contact page are your standard fields that relate to
customers: FirstName, LastName, Phone, Address...ect. This is where the
permanat address is. The fields that I would like to parse are on an
Alternate Address page which could be "screwed up" if the user decides
to but the purpose of parsing is to then concatenate these new fields
into reports (letters) that will get mailed.

Thank you for your - help?