Text field size

[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

 

[Jerry Whittle]

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.