Working with street numbers and addresses is problematic. There is no good
way to make sure that any parsing operation will work the way you want it to
in every instance. Every time I have ever tried this, it has failed, and
I've resorted to manual inspection.
Generally what I do is create a continuous form that displays the # and
address field, and the Street_Numb and Street_Name fields.
I then set the forms keypreview property to Yes, and add some code in the
keydown event of the field that contains both the # and address. That code
checks for a particular key code (I like to use the ASC("z")). If it senses
that the "z" has been pressed, it parses everything to the left of the cursor
position into the street#, and everything to the right into the street name.
After that, it sets the KeyCode to 0 and then moves to the next record using
the docmd.GoToRecord ,,acNext method.
You should be able to do 20 or more records a minute using this technique.
Although this is very tedious, I've found that I have to review every record
for accuracy when I try any sort of automated version of this, so you might
as well get it right from the start. All you really have to do is click your
mouse at the breakpoint in the field with the # and street, and then press Z.
I generally offer my clients the opportunity to do this themselves, as they
generally have someone else that can do this at a significantly lower labor
rate, but if they don't want to do it, I do it myself and charge them my
normal rate.
--
HTH
Dale
email address is invalid
Please reply to newsgroup only.
