Access 2010 Len Function in query grid

Hi Experts,

I utilize the Len function to count the number of characters in a datafield [H_SVP] which contains such data as A, BB, DDD, etc.  I use Len([H_SVP]) in a database which normally returns 1, 2, 3 respectively.

For some reason I return no results when I use the exact same field and len function in a different database....I don't get an error message just blank cells when I run the query.

I tried creating a new database and importing everything in case I had a bug but that didn't work either.

Any idea on why the Len function wouldn't work?
grmcraAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try doing this in the immediate window

?len("ABC")
3

did you get the correct result? No error?



* Open your references, from VBA window
Tools > References
check for any MISSING ref, uncheck and locate the available reference and select
click OK

in VBA window
do a debug >Compile
correct any error raised
0
 
grmcraAuthor Commented:
...thank you, when I unchecked and then rechecked the references it worked.
0
All Courses

From novice to tech pro — start learning today.