M Milade8080 Registered User. Local time Today, 16:50 Joined Mar 6, 2014 Messages 34 Jul 11, 2014 #1 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??
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??
C CJ_London Super Moderator Staff member Local time Today, 23:50 Joined Feb 19, 2013 Messages 17,059 Jul 11, 2014 #2 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
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
P plog Banishment Pending Local time Today, 18:50 Joined May 11, 2011 Messages 11,830 Jul 11, 2014 #3 Set the validation rule to this: (>99999999999 AND <100000000000) OR 0
M Milade8080 Registered User. Local time Today, 16:50 Joined Mar 6, 2014 Messages 34 Jul 11, 2014 #4 CJ_London said: 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 Click to expand... Tank you Good luck
CJ_London said: 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 Click to expand... Tank you Good luck