fredg,

It happens at ANY occurance of the Left function. In a query or in VBA.
Below is the exact usage of it. NALID2 is an address field and we are
looking for P.O. Boxes.
Pbox: Left([NALID2],4)

But I've tested it in code and a blank query with an example like: Left
("Blah",2) Which I would have though would give me "Bl" back.

fredg wrote:
Thank you so much everyone for your assistance. I still can not find my
issue though after trying all your suggestions and reading attached websites.
[quoted text clipped - 26 lines]
Thank you all again for your assistance and any more thought you may have on
this would be GREATLY appreciated.

How about posting the complete exact expression you are trying to use?

--
Message posted via http://www.accessmonster.com