Count Character

  • Thread starter Thread starter zyus
  • Start date Start date
zyus said:
How to count the maximum number of character that i have in my IDNO field.

Thanks

Create a Query based on your table. In a vacant Field cell type:

HowLong: Len([IDNO])

Sort descending by this field, or use a Totals query and select Max on it.
 
This depends on the fieldsize you've set in tabledesign. Go to the table
where the field resides. Look in designview. Click in the IDNO field and look
at the bottomhalf of the screen. You should see the fieldproperties and the
first is telling you the fieldsize of the field. Most of the times the
default will be set to 50 (for text datatype). You can increase that to 255
chars.

hth
 
Back
Top