Changing properties on a continuous form

[mcomp72]

I have a continuous form, and there's a button on it that runs some VBA code. The code takes information that's in the detail area of the form and writes it to a table.

There will be some records on the form that will be ignored -- every record will not have data that gets written to the aforementioned table. For the records that do, I would like to have the background color of one of the fields in the detail area of the form changed to blue.

The way I have thinking about it is, after the code runs that writes the data to the table, I could then do the following:

Loop through each record on the continuous form and do this:
If the ScoreRecorded field = True then make the background color of the Points field blue.

ScoreRecorded is a field of type YES/NO.

I have tried to figure out how to do this, but I can't seem to get it. I found a post on StackOverflow that talks about using Me.Detail.Controls, but I can't figure out how to make sense of it.

Any ideas on the best way to do this?

 

[CJ_London]

Have you tried using conditional formatting?

 

[mcomp72]

Nope. Had never even heard of it. I knew Excel could do that, but not Access. I'll google it and read up on it. Thanks!

 

[CJ_London]

It works much the same way although some controls such as subforms and checkboxes cannot be conditionally formatted