Need to determine length of field for query

[Barry]

I need to use a query that will show me in the address field all those
records where the address is longer than 35 characters. I want to be able to
shorten those to fit in a specific label. I can then use this syntax to also
abbreviate city names that are too long for the label

 

[John W. Vinson]

I need to use a query that will show me in the address field all those
records where the address is longer than 35 characters. I want to be able to
shorten those to fit in a specific label. I can then use this syntax to also
abbreviate city names that are too long for the label

Create a query based on the table with a calculated field

AddrLen: Len([address])

Put a criterion of

35

on this field to find all the verbose addresses.

Abbreviating the city might not be all that easy, unless you were to have a
table of city names and acceptable abbreviations; you may want to do these
manually if there aren't too many.