[AccessD] Field Sizes

On 25 Aug 2005 at 11:27, John Clark wrote:

> 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?
> 

We've had this discussion before <g>

255 characters.

Access doesn't use fixed length storage for strings and you don't save any 
space by defining text fields as less than the maximum allowable.  I change 
the default field size for text strings to 255 in Options and never change 
it for individual filed definitions.

All that restricting field sizes does for you is increase the risk of 
truncating data or throwing up error messages at the user sometime in the 
future.



-- 
Stuart