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!

Validate field

Status
Not open for further replies.
lbonsemb

lbonsemb

Technical User
Dec 1, 2001
4
US
I have a field that has the following format wxy-z (all of which are numbers). I need that after the user inputs data into it this condition is met: z= MOD ((w*2+x*3+y*4)/11). If this condition is not met an error message box pops up.
I couldn't validate this field within the field properties box (I am not saying it cannot be done). I guess this has to be done through code. Please give me a hand.

Thanks,

Luis
 
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
455
dhookom
dhookom
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
383
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
229
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