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 derfloh 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
Joined
Dec 1, 2001
Messages
4
Location
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 Question
Code to write file path to field always writes to 1st record
Replies
5
Views
1K
dhookom
dhookom
Moss100
  • Locked
  • Question Question
Vba adding record to table when field is integer
Replies
8
Views
885
Moss100
Moss100
JayRo71
  • Locked
  • Question Question
docmd.TransferText not importing a number field
Replies
1
Views
624
JayRo71
JayRo71
Johnny S
  • Locked
  • Question Question
Create folder based on ID field MS Access
Replies
3
Views
573
MattGreer
MattGreer
OzFoxy
  • Locked
  • Question Question
How to get AttachmentCount from a field in a table
Replies
2
Views
443
OzFoxy
OzFoxy

Part and Inventory Search

Sponsor

Back
Top