mandatory field size within table

R

Robert

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.
 
K

Kevin B

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
 
E

Earl Kiosterud

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...
 
R

Robert

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.
 
G

Gord Dibben

This is an Excel news group.

For Access questions see an Access news group.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Rule need help 6
Insert Index into a Table 1
Different fields "Required" 1
Shift several columns in table 4
Summary Report 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Query-matching data with multiple choices 5
Create Field in table and define it's position 1

Top