I have found that when I mass-update a field, it is not recognized the same way as if I enter the information directly.    Is there a way to correct this?

I hope this is sufficient to identify my need; otherwise, I will need to describe precisely what I am doing, which will be rather lengthy.

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!

Ray -

The address appears absolutely correctly as:  6000 NW 64th Ave Apt 101

It does not have the decimal point and does not have any trailing zeroes.  Even so, I tried the programming, as you suggested, and it did not make any difference.

I had also tried (without success):

StreetAddress="6000 NW 64th Ave"+" "+"Apt" + " "+@str(Condo Unit)
 

Any other ideas?

Thanks!

Ray,

The DB and DAT files are on their way.  I'm looking forward to the solution.

Thanks!

Ray -

Question!

What is the reddest face you have ever seen?  I guarantee that mine - right now - will beat it.  I just touched my hand to my face and got a third-degree burn on my hand.  lol

Seriously - the Address1 field works "behnd the scenes" so-to-speak and, as a result, I had forgotten all about it.  It probably never would have occurred to me in a million years.

Thanks, so much, for the clear explanation and yet another easy solution.

(Wonder how long it will take for my face to cool down!).