Hello all, I hope the day is going well for everyone.

I am currently working with continous form, and I have a question about making conditional presentations for each record on the form. For example, let's say each record on the form has a "score" field which is an integer between 0 and 100. If, for that record, the score is below 60, I would like the color of that text field to be red for that record. Any other records with a score of 60 or above would keep the default color.

I am decent with VBA, and I have been playing around with the OnLoad event, but that I can't that to work yet.

Anyways, thanks for the help. Have a good one.

Use the detail section's On Format event. If you use conditional formatting, then all the records willl turn red if any of them meet the criteria. Use the on format event and do this:

If Me.Score < 60 Then
   Me.Score.ForeColor = vbRed
Else
   Me.Score.ForeColor = vbBlack
End If

Did that work?

mmcdonal

Thanks for the reply. When I pull up the Detail section's properties, I do not see an On Format event. I am using Access 2003. Do you know if this is something available on a different version of Access?

These are the available events listed under the Detail section:

On Click
On Dbl Click
On Mouse Down
On Mouse Move
On Mouse Up

It looks like all of these events are dependant on user interaction.

Thanks for the help.

I was wrong, use the conditional formatting.

Select the score field in Design View, select Format > Conditional Formatting, then set the properties to:

Greater than, 60, Red (Bold?)

Sorry for the run around.

mmcdonal