Field adjustment under certain conditions

Milade8080

Registered User.
Local time
Today, 16:50
Joined
Mar 6, 2014
Messages
34
How do I set a field to the table so that it will accept only the number 0 or a 12-digit number
Can someone advise me??:confused:
 
you set a validation rule in the control properties on a form or the field properties in a table.

the validation rule would be something like

=0 OR (>=100000000000 AND <=999999999999)

and so the user knows why an entry is invalid , put something like

'Number must be 0 or 12 digits long'

in the validation text
 
Set the validation rule to this:

(>99999999999 AND <100000000000) OR 0
 
you set a validation rule in the control properties on a form or the field properties in a table.

the validation rule would be something like

=0 OR (>=100000000000 AND <=999999999999)

and so the user knows why an entry is invalid , put something like

'Number must be 0 or 12 digits long'

in the validation text

Tank you
Good luck
 

Users who are viewing this thread

Back
Top Bottom