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.

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.

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.

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.

sorry i thought i was posting in the Access discussion Group
 

sorry wrong group

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.