I am new to Access. Rather than figure this all out myself, this must
have been done thousands of times. Are there are standards for how
long (in characters and inches) text fields reasonably need to be for
both tables and forms? The ones I can use immediately and therefore
can think of are: First Name, Last Name, Company Name, Street Address,
City or Town, Country, Postal Code (international), Telephone Number
(international or at least NADP & Europe), Email Address, Occupation,
URL, username (for an account), Password, Job Title, Language (i.e.,
human language).
This should even be automated with tools.
And how about a library of validation routines in VB for all these
types (e.g., validate phone # is NADP if in NA and area code matches
state if US; many other things are all letters, etc.)? Do any already
exist? Why re-invent the wheel?

mmodica (AT) earthlink (DOT) net (Michael M.) wrote in message news:<4d99ef25.0310141457.635269fb (AT) posting (DOT) google.com>...
Hello Michael,

Do an Access help search for "Specifications" and "Validation". Both will
help out alot.

Regards,

Ray