Change Bg (1 Viewer)

[k0r54]

Hi,

I have a form with a subform that is set to continuous.
I have a field [Info][.RemovedP]. What i want is if RemovedP = -2 then i want the bg colour of JUST that record to be changed.

The default is blue, so what i will then get is blue bg for all the records accept if the RemovedP ='s -2, it will then be red.


Hope this is clear enough.

Thanks
k0r54

 

[jgrayek]

Open the subform in design mode, highlight every control in the row, Click Format->Conditional Formatting. Use Expression type. Enter [RemovedP]=-2 and set the formatting for that condition.

Jesse

 

[k0r54]

If i highlight them all, the conditional formating is disabled. All i need to do is change the background colour of the details bit in the form. But when i try clicking on details, it also fails.

Thanks
k0r54