How to find shortest longest length of characters in a set

Solution

Solution:

longest lenght of characters:

You could iterate through the fields in the table and, for the text data type fields, run a Select Max(Len([fieldname])) From Tablename query, where the [fieldname] was the current iteration\'s field name. Assigning the results of such a query to a recordset variable would give your code access to this for output or automated field resizing.

shortest length characters:

you can find shortest value in microsoft access using with Min(Len([fieldname])).

Example:

=INDEX(A2:A11,MATCH(MIN(LEN(A2:A11)),LEN(A2:A11),0)), and remember to press Shift + Ctrl + Enter keys at the same time.