Conditional Format records in continuous form

  • Thread starter Thread starter Terry Holland
  • Start date Start date
T

Terry Holland

I have a continuous form that displays records that will be in various
status. I would like to somehow highlight records that are in various
status. eg Hightlight red those recs that are in status 1, Blue for those
in status 2 etc.

Is this possible?
 
Terry said:
I have a continuous form that displays records that will be in various
status. I would like to somehow highlight records that are in various
status. eg Hightlight red those recs that are in status 1, Blue for those
in status 2 etc.
Click to expand...


Within limits, it's possible. Typically, this is done by
adding a text box and sizing it to be a big as the entire
detail section. Then use the Format - Conditional
Formatting menu to specify the condition and BackColor
property for up to three different colors beyond the default
setting.

Set the text box's Locked property to Yes and Enabled to No
so the user can not select it. Finally, use the Format -
Send to Back menu item to place this large text box behind
the other controls.

You will probably want to set all the other control's
BackStyle to Transparent so the highlight color shows
through.
 
Back
Top