Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
mandatory field size within table
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
mandatory field size within table
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
mandatory field size within table
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorry i thought i was posting in the Access discussion Group
sorry wrong group
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
mandatory field size within table
This is an Excel news group.
For Access questions see an Access news group. Gord Dibben MS Excel MVP On Thu, 30 Aug 2007 15:28:02 -0700, Robert wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Format - Field Size | Excel Discussion (Misc queries) | |||
How to make a field created a part of the Pivot Table Field List? | Excel Discussion (Misc queries) | |||
mandatory field | Excel Discussion (Misc queries) | |||
Auto size a pivot table to a page size | Excel Worksheet Functions | |||
how do you set up a mandatory field in Excel? | Excel Discussion (Misc queries) |