Changing forecolor in selected subform records

  • Thread starter Thread starter JKlein
  • Start date Start date
J

JKlein

I am looking for a way to highlight certain records showing in a subform.
Something like this.

If clientID = "377" then
clientid.forecolor = 255 else
clientid.forecolor = 0
endif

I have placed code like this in the subforms on current event...does not
work.
Any ideas??
 
I am looking for a way to highlight certain records showing in a subform.
Something like this.

If clientID = "377" then
clientid.forecolor = 255 else
clientid.forecolor = 0
endif

I have placed code like this in the subforms on current event...does not
work.
Any ideas??
Click to expand...

If your version of Access supports Conditional Formatting (Access 2000
or newer), set the ForeColor property of this control to Black (0).

Then select the [ClientID] control and click on
Format + Conditional Formatting.
Set the Condition1 for the ClientID control to:
Field Value is
Set the Value to
equal to 377
(if Client Id is a Number datatype. If ClientID is Text datatype use
"377".)
Set the ForeColor to Red.
Save the settings.
 
Back
Top