In a continuous form, is there a way to 'highlight' (change backcolor) of either the entire row or even just one field of the form.

For example, if we have the following table:

CUSTID STATUS

328893 Current
229338 Closed
993002 Current

I would like the backcolor to change to yellow where status='Closed'. This is easy enough to do in a report;

if me.status = 'Closed' then
 me.status.backcolor = vbYellow 'in the detail_print event.
end if

However, I cannot find the equivalent for a continuous form.

Thanks in advance.
Kevin Scott

With ac2K+ you can use conditional format on TextBoxes in a continuous form if the control is bound.

HTH RuralGuy (RG for short) acXP WinXP Pro

Thx RG.. I'm using Access 2002 in WinXP. I can put a textbox on the row somewhere no problem.

Do you have any more details on how to use this "conditional format" functionality.

RG!!! Figured it out rereading your response. Thank you so much for that tip.

Very appreciated!!