Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in Access only
Search
Advanced Search
Forums
BYTES
Product Launch
Updates
Developer Toolkit
Today's Posts
Member List
Calendar
Home
Forum
Topic
Access
How do I write a validation rule?
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
Tina Campbell
New Member
Join Date:
Apr 2011
Posts:
1
#1
How do I write a validation rule?
Apr 27 '11, 06:04 PM
how do I write a validation rule to require a 6 digit number in a field?
ADezii
Recognized Expert
Expert
Join Date:
Apr 2006
Posts:
8834
#2
Apr 27 '11, 07:04 PM
I think that you are actually referring to an Input Mask. To force a User to enter exactly 6 Digits into a Field:
Create the Field in the Table and define it as:
Data Type: TEXT
Field Size: 6
Set the Input Mask Property to: 000000 (6 Zeros)
Comment
Post
Cancel
Previous
template
Next
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕
Comment