Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Validation Rule / Input Mask

Status
Not open for further replies.
CHTHOMAS

CHTHOMAS

Programmer
Jun 16, 1999
106
AE
Hello Everybody,<br>I want the 1st two characters in a field as digits, 3rd a blank space and from 4th ownwards any combination of letters or digits. Eg. (66 abcd)<br>How to do that?<br>Thanks<br>Charley
 
Sort by date Sort by votes
Enter this in the input mask field in design view for your table:<br><br>&quot;00 CCCCCCCC&quot;<br><br>This will allow you to enter up to eight characters after the space. Add or delete &quot;C&quot;s as needed.&nbsp;&nbsp;See the help entry for InputMask Property for more detail.<br><br>Hope this helps.&nbsp;&nbsp;Let me know if you need more.<br><br>Kathryn
 
Upvote 0 Downvote
or try this<br><br>00&AAAAAAA<br><br>0 = Digit 0 to 9 Required<br>& = Any character or space Required<br>A = Letter or Digit entry Required<br><br>Or<br><br>00Caaaaaaaa<br><br>Same as above except <br><br>C = optional<br>a = note lowercase optional<br>
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
621
atadbitslow
atadbitslow
Moss100
  • Locked
  • Question
User input filtering records
Replies
1
Views
139
PHV
PHV
dmhgt3
  • Locked
  • Question
Access 2007 - Collect data via Outlook with validation rules
Replies
1
Views
110
genomon
genomon
47redlands
  • Locked
  • Question
MS Access input mask
Replies
1
Views
165
MazeWorX
MazeWorX
Artois27
  • Locked
  • Question
Validation Issue 1
Replies
13
Views
375
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top