Erika -
lol - guess you need more info - ok - here goes ....
I have a database that includes the following fields: Street Address, City, State & Zip
I also have a button (USPS) and when I click on it, it sends the first 3 fields to the US Postal Service Zip + 4 lookup (a website). It opens the website and walla, there is the correctly formatted address and the zip+4 code. I simply copy the code and paste it back to my database. (I have been blessing Bob Hanson all the years that I have been using this feature).
There is also a field, in the database, called Condo Unit which has the apartment # for each apartment in the building.
I added 36 records to the database and put the Condo Unit # for each apartment in that field for each of the 36 records. (I don't know whether it makes any difference; however, the Condo Unit # is formated as a numeric field).
I then did a mass update to the 36 records to have the address fields properly completed. Here's the programming I used:
StreetAddress="6000 NW 64th Ave"+" "+"Apt" + " "+Condo Unit
City = "Tamarac"
State="FL"
When I go to the record and click on the USPS button (to perform the lookup), I get a message that says:
We're sorry! We were unable to process your request.
When I look at the website, I find that the city and state appear correctly; however, the Address field is blank.
(This is what I meant by not "recognized")
One of the things I found I can do - in the database - to resolve this is (1) click on the address field and "cut" the address, (2) click on any other field in the databse (3) go back to the address field and "paste" the information back into the field.
Now when I click on the USPS button, the lookup is performed properly.
This is a lot of work - for something that was extremely simple - and there must be something I can do to "fix" it.
I tried a mass update to simply have the Street Address = Street Address, but that didn't accomplish anything. My lookup still failed.
Hope this additional info is helpful.
Thanks!