Maximum *width* of data in a table (Access 2003)

[RKSpangler]

Greetings:

Is there any way to determine the maximum width of all data elements
in a particular column in a table? Sorting a column won't do it, of
course, since it will use a collating sequence based on the content of
the data. I want to know, for example, that the maximum width of a
(non-blank) populated field in a table is, say, 10 (even though the
field itself may be defined as width-255).

Many thanks.

[Chuck]

On Sat, 02 Jun 2007 21:36:53 -0000, RK********@gmai l.com wrote:

>Greetings:

Is there any way to determine the maximum width of all data elements
in a particular column in a table? Sorting a column won't do it, of
course, since it will use a collating sequence based on the content of
the data. I want to know, for example, that the maximum width of a
(non-blank) populated field in a table is, say, 10 (even though the
field itself may be defined as width-255).

Many thanks.

Make a query of the table showing only the one column in question.
Add a calculated column, say for the length of a persons last name,
lgthLastName:([LastName])
set sort order to Descending

Just a wizard prodder
Chuck
--

[fredg]

On Sat, 02 Jun 2007 21:36:53 -0000, RK********@gmai l.com wrote:

Greetings:

Is there any way to determine the maximum width of all data elements
in a particular column in a table? Sorting a column won't do it, of
course, since it will use a collating sequence based on the content of
the data. I want to know, for example, that the maximum width of a
(non-blank) populated field in a table is, say, 10 (even though the
field itself may be defined as width-255).

Many thanks.

What do you mean by "maximum width"?
The number of characters in the field?
In a query?
Add a new column:
MostChars:Len([FieldName])

Set this column to sort Descending
The record with the most characters will be first.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail