Highest character count in a field

[Wayne Cramer]

I have a large table (over 20,000 records) where the text fields were all set at 255 - even those requiring a single character entry. Is there a way to determine the highest existing character count for each field so I can set the text fields to a reasonable setting? After a compact and repair will existing records be set to the new setting?

 

[Rabbie]

Access only uses the actual number of chars needed to save a string. The Text field size just sets a maximum so you won't save any space by changing this.

In answer to your question MAX(len(fieldname)) will give you the length of the longest entry in a given field.

Hope this helps