TEXT FIELD SIZE

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.
 
J

Jerry Whittle

Hi Tom,

Please don't cross-post questions. I've answered this question in another
forum.
 
T

Tom

When originally posted I thought it being in general questions was wrong.
Will not do it again Sorry about that
 
G

Gérard Lemieux

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text field size 1
why "Type Conversion Failure" import EXCEL into ACESS TEXT field 1
Text Field Size - Access 2007 2
Type Conversion Failure importing number as text 1
Importing Text Files Into Access 1
Datatypes 1
Field size reduction on import of Excel, txt, etc files 2
Trying to add Long Integer field 1

Top