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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Field validation

Status
Not open for further replies.
pcdaveh

pcdaveh

Technical User
Sep 26, 2000
213
US
I'm looking for the syntax to put in field validation. I have an account number that takes this format: ##-####.0 or 23-7846.0 as an example. I want to set up a validation rule to handle that. Can anyone help?
 
Sort by date Sort by votes
Do you mean an input mask, which would ensure the data is entered like that, or an actual rule to disallow certain values from being allowed within the string? James Goodman
 
Upvote 0 Downvote
I'm looking for a validation rule. I'm already making use of the the input mask. I want to be sure that no account numbers of a shorter lenght get entered by mistake. With the input mask you could begin to enter an account number but it wouldn't force you to have the proper length.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
453
dhookom
dhookom
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
378
Moss100
Moss100
JayRo71
  • Locked
  • Question
docmd.TransferText not importing a number field
Replies
1
Views
306
JayRo71
JayRo71
Johnny S
  • Locked
  • Question
Create folder based on ID field MS Access
Replies
3
Views
228
MattGreer
MattGreer
OzFoxy
  • Locked
  • Question
How to get AttachmentCount from a field in a table
Replies
2
Views
193
OzFoxy
OzFoxy

Part and Inventory Search

Sponsor

Back
Top