Address

[dogbite via AccessMonster.com]

How do I seperate the numbers from the street name when it gets to the report?

I enter both in an address text and other info but when it gets to the report
I need them in seperate text boxes.
Access 2000
Thanks Lee

 

[Guest]

Open a module/code window and search Help on Instr(), Mid(), Left(), Right().

 

[Guest]

You can extract the street numbers if there is a space between them and the
street name. An example is a [Street] field containing data 1234 Main. The
trick is to locate the space between the numbers and the street name. Try
this built-in function. It’s worked for me when I have a person’s full name
in one field, and I need to separate first and last name. Hope this helps!

Left([Street], InStr([Street], " ") - 1)

Daisy