Text field size

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I want to import data into a new table in Access 2007. Under Access Options,
then Object designers--I put 50 in as the Default text size. But anytime I
import data and it is a text field it will automaticlt make it 255 no matter
what i do. I am trying to limit the size of the Database since most of my
data would never exceed 50.

Thanks
 
The good news is that Access doesn't waste space in text field. Even if the
field is sized to 255 characters, if you put 50 characters in it, that's all
it uses.

About the only downside to having it set at 255 is that a form or report
wizard might look at that value and make a text box much too long.

In a nutshell: Don't worry. Be happy.
 
Back
Top