Leading Space infront of string

[gblack]

I am having an issue with some imports. As you will be able to see from the attached Db file, some fields import into MS Access with a leading space in front.

The problem is, Access doesn't seem to see it. For example, (in Query_1) I try to find the leading space with a Left and a Mid function using: " ", "", and Null... but none of these criteria match.

However if you use Left(string, 1)... the empty space will post. So my question is: How can I programmatically eliminate these leading spaces when I can't state if there is a leading space or not?


Take a look...

 

[gblack]

Hmm... I just ran an ascii check using ASC() and it gave me the value 160... which is some weird symbol.

So if I look for a value of chr(16) within Left([String],1) that does the trick.