Row with the largest character count

[efandango]

Is there a way of finding out which field row has the largest character count?.

I want to chop the field lengths to make the database run faster, but don't
want to chop any real data off.

the table is tbl_Street_Names
the field is: StreetName

 

[KARL DEWEY]

Use a query sorted descending --
Field_Size: Len([StreetName])

 

[John Spencer]

By the way, decreasing the field size will have no effect on the speed of the
database.

Assigning an index to the field may improve the speed of record filtering
(selection) and sorting when you are filtering or sorting by the field StreetName.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[John W. Vinson]

Is there a way of finding out which field row has the largest character count?.

I want to chop the field lengths to make the database run faster, but don't
want to chop any real data off.

the table is tbl_Street_Names
the field is: StreetName

Don't bother.

The size of the field only trivially affects the speed of the database.
Indexing the field will make searching it VASTLY faster, regardless of its
size; and as soon as you truncate the field to 20 characters, you'll get a new
address on Hanuakupalukamakalahana Boulevard. (No, I don't think it's real...)

I believe the US Postal Service has a standard limit on name lengths, you
might just want to go with it.

 

[efandango]

Very perceptive of the two John's... I didn't realise that field length has
so little impact on overall speed. (though I could have sworn i've read stuff
on here that say's that it does)

any thanks guys (you too Karl), at least i won't have to waste my time
retro-cutting umpteen tables.