View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default 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.