Help with field lengths

[Lisa - NH]

Hi. Somewhere in my reading, I found a list of estimated field lengths for
various fields. I can't recall where I found it. I have already changed the
size for things like state, zip, phone, etc. I'm looking for estimates for
First Name, Last Name, City and e-mail. I just don't see a need to keep it
at 255.
Lisa

 

[fredg]

Hi. Somewhere in my reading, I found a list of estimated field lengths for
various fields. I can't recall where I found it. I have already changed the
size for things like state, zip, phone, etc. I'm looking for estimates for
First Name, Last Name, City and e-mail. I just don't see a need to keep it
at 255.
Lisa

No need to change the field size of a Text datatype field.
Access only 'charges you' for what you actually use.
So if your data is 25 characters, memory used is 25 characters, not
255.
However, if you have a requirement to limit the user's data entry to
under a specific number of characters, i.e. limit the State entry to 2
characters, then it would make sense to change the field size.

 

[Lisa - NH]

Hi Fred,

Thanks, I appreciate it.
Lisa