Help with field lengths

  • Thread starter Thread starter Lisa - NH
  • Start date Start date
L

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
 
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
Click to expand...

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.
 
Back
Top