I adjust the field size when I want to limit the data that the users put in
I storey phone numbers as a text string as I have no need to work with or manipulate the data
So on that field I have dropped the field size to 15 char or so. Otherwise may end up with someone putting notes there as well
I have a separate field for the phone notes
Take care,
Michael
>________________________________
> From: Jerry Mathers <jerrymathersasthebeav@yahoo.com>
>To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
>Sent: Friday, May 24, 2013 5:46 AM
>Subject: [MS_AccessPros] Field Size
>
>
>
>
>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]
>
>
>
[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 (2) |
Tidak ada komentar:
Posting Komentar