ions
09-28-2006, 07:12 PM
I just discovered that field lengths don't influence table size because Access doesn't pad fields.
A text field with length 20 or 255 doesn't impact the size of the table, just the data in the field does.
I did a test to confirm this.
This blew me away.
So now I ask why do we specify field length for text fields?
A text field with length 20 or 255 doesn't impact the size of the table, just the data in the field does.
I did a test to confirm this.
This blew me away.
So now I ask why do we specify field length for text fields?