Datasheet view form formatting issue.

On a datasheet view form if the user selects a particular checkbox as true we want the background color of every field for that record to turn blue.

How can this be done?

--Steve
SteveL13Asked:
Who is Participating?
 
Dale FyeCommented:
Yes,

You would need to open the datasheet form in design view, select all of the other textbox or combo box controls in the form, and then click on Conditional Formatting.  When you get into the conditional formatting, change the combo to Expression and enter something like:

[checkBoxFieldName] = -1

And then set the background color to blue.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.