[AccessD] Field Sizes

Hi John:

Off the top but as far as I know there are no standards but lengths that
have worked in the past are as follows:

Firstname: 15
MiddleName: 25 (can be multiple)
LastName: 25

AptNumber: 5
Address: 10
StreetName: 25
City: 15

There are of course items which extend outside but 98% of the time these
have worked.

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Thursday, August 25, 2005 8:28 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Field Sizes

I've got bigger problems right now, but I've meant to ask something
forever and...well...today is the day, I guess. What do y'all use for
standard sizes for typical text fields, such as Last Name, First Name,
Address, City, etc.? Is there a "common practice rule" concerning this?

And, just to get the yuks outta the way, I guess I could have changed
the subject line to, "does size matter?"
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com