mandatory field size within table
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
--
Kevin Backmann
"Robert" wrote:
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.
|