mandatory field size within table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Click DATA in the menu and select VALIDATION. For the VALIDATION CRITERIA,
drop down the list and select TEXT LENGTH. From the DATA combobox select
EQUAL TO and in the LENGTH field enter the number 12. Then click on the
ERROR ALERT tab and give your users an error message of some type.

Then click on
 
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...
 
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.
 
This is an Excel news group.

For Access questions see an Access news group.


Gord Dibben MS Excel MVP
 
Back
Top