Highlighting a row or field in a continuous forms form

[JR]

I have a flat database and am using a continuous forms form to display the
table. What I would like to do is highlight either one field or the entire
row of each record in the table that meets certain criteria. For instance,
if field1 > 0 then highlight the record, or a field in the record. I would
like this to happen when the form is opened.

I can do VBA but I've looked for a way to do it using VBA and can not figure
out how. I feel like this is possible and I'm hoping one of you more
experienced guys would be able to help me.

 

[JR]

Thank you James. I have been using Access for years and have never used that
before and actually didn't know it even existed. Funny how you get in a rut
doing the same old things over and over and don't realize what else is
available.

After trying this via the menus, I figured it had to be available
programatically and sure enough it is, via the Me.field.FormatConditions
function. Thanks again for turning me on to this. I appreciate it.