If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text field size
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 -- Tom |
#2
|
|||
|
|||
Text field size
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. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Tom" wrote: 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 -- Tom |
Thread Tools | |
Display Modes | |
|
|