Validating a field

  • Thread starter Thread starter Kim Jackson
  • Start date Start date
K

Kim Jackson

If have a field that I need to be a constant value of
$100 if a value is entered. How can I make a the form
validated what is entered and give a warning if anything
other that $100 is entered.
Thank you for the help.
 
Use the TextBox_BeforeUpdate Event and compare the value in the TextBox with
100.
 
Thank you
-----Original Message-----
Use the TextBox_BeforeUpdate Event and compare the value in the TextBox with
100.

--
HTH
Van T. Dinh
MVP (Access)






.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation Rules for a Control on a Form (?) 4
Validation in child form 1
Validation Rule Error Messages 1
validation help 3
DATA VALIDATION RULE BASED VARIED ENTRIES IN ANOTHER FIELD 1
Validating a Field 5
Access compare fields in a table 0
Validation Rule assistance 0

Back
Top