The real issue isn't storage space. It's control over the data entry. Access text fields are actually varchar data types. Their upper limit can be set, but the data only takes up the space required. So the only reason for setting the upper limit is if you have a need such as Social Security numbers will always be 3-2-4. Not setting the upper limit on that field to 11 (including dashes) could lead to extra numbers being accidentally entered.
Another good reason for setting the upper limit to a specific size less than 255 is so you can take advantage of the auto tab property where filling in a textbox with the specified length will trigger a tab to the next field.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, Jerry Mathers <jerrymathersasthebeav@...> wrote:
>
> I know this isn’t much of a real issue, but I’m confused about the need, or not, to adjust the Field Size property in a table. I’ve read about this, but all I seem to get is conflicting opinions.
>
> Originally I thought I should adjust the field size to best match the data that will reside in the field. I did this because I thought that it would reduce the size of the Access file as well as make it more efficient in storing the data. Then I read that it doesn’t make any difference if a change the default 255 to a lower number because Access dynamically creates the necessary space and it doesn’t increase the overall file size. (Maybe this was more of an issue in earlier versions of Access.)
>
> Can anyone offer anything approaching a definitive answer to this mini-dilemma? Does it matter? If not, are there still good reasons to adjust the field size property to a number lower than the default?
>
>
> [Non-text portions of this message have been removed]
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar