By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Why 50 character fieldsize default for text field type?

P: n/a
Hello,

This is something that's bothered me for quite a while. Does anyone
know why Access has, for so many years, defaulted to 50 characters for
the fieldsize value when setting a table field's datatype to text?
Since Jet does not preallocate space based on this value, I'm not sure
what the point of this particular default value is. Why not default
to, say, 64, or 128, or the full maximum allowable 255? Or maybe a
nice prime number like 53? What's special about 50?

Bruce
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
IMO, making the field size no larger than it needs to be is a good sanity
check, and people's names, company names, telephone number with extensions,
etc., generally fall between 15 and 25 characters most of the time. Since the
exceptions to anything can be fairly exceptional, it's good to double whatever
seems to be the likely maximum necessary for a character field, and that makes
50 a pretty appropriate number a lot of the time.

Other numbers I find myself using frequently are 255 (of course), 30, 40, and
100.

On 23 Aug 2004 12:15:40 -0700, br***@aristotle.net (Bruce) wrote:
Hello,

This is something that's bothered me for quite a while. Does anyone
know why Access has, for so many years, defaulted to 50 characters for
the fieldsize value when setting a table field's datatype to text?
Since Jet does not preallocate space based on this value, I'm not sure
what the point of this particular default value is. Why not default
to, say, 64, or 128, or the full maximum allowable 255? Or maybe a
nice prime number like 53? What's special about 50?

Bruce


Nov 13 '05 #2

P: n/a
On 23 Aug 2004 12:15:40 -0700, Bruce wrote:
Hello,

This is something that's bothered me for quite a while. Does anyone
know why Access has, for so many years, defaulted to 50 characters for
the fieldsize value when setting a table field's datatype to text?
Since Jet does not preallocate space based on this value, I'm not sure
what the point of this particular default value is. Why not default
to, say, 64, or 128, or the full maximum allowable 255? Or maybe a
nice prime number like 53? What's special about 50?

Bruce


If you're not happy with 50 you can change the default text size to
what ever you want, up to 255.
Tools + Options + Table/Queries
Enter the size in the Table Design - Default Field Sizes - Text box.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.