Count Number of Characters

  • Thread starter Thread starter Kevin C.
  • Start date Start date
K

Kevin C.

I have a field in a database Called Agency. The Agency
number is either 8 character or 9 characters long. I
want to do different thing with the agency number but
they are dependant on the size of the Agency number. Is
there a function that can count the length of the data
entered in the Agency number field?
 
Len([AgencyCode]) should return the length.

Check Access VB Help on the Len() function.
 
Back
Top