Validation Rule and color

  • Thread starter Thread starter Regalibar
  • Start date Start date
R

Regalibar

Hi All,

Is there a way to have a field with a validation rule change color rather
than pop-up the validation text if the validation rule has been violated? I
have a database with several required fields and it would be better if, once
the employee submits the data, the improperly entered fields could be
highlighted in some way.
 
You might want to take a look at Conditional Formatting... depending on what
version of Access you have.
 
This goes in the format line in the properties box.

"Above Limit"[Red];"";"On The Edge!"[Blue];""

You can change the [bracketed]colors.
 

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

conditional validation rules 5
Text Field Validation Rule for Date 1
Validation rule for Access 2003 2
Validation Rule Problem 2
Help with validation 3
table level validation 7
validation rule 4
A table validation rule question. 6

Back
Top