it must be different in Access 2007, i have validation rule and validation
text, but no text length to be found in the expression builder.

"Earl Kiosterud" wrote:

Robert,

Data - Validation. Set Allow to "Text length" and go from there.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"Robert" wrote in message
...
Can I create a mandatory number of characters in a field when creating a table.
Table 1
Field1 date
Field2 Time
Field3 (12 digit number required by user) 123456789012

If the user does not enter a 12 digit number in field 3 they will receive an
error message and the record will not be created.