Conditional Formatting

[Eddie Mason]

Changing field colour

Hi All,

Is there any way of changing the colour of a field on a continuous sub form? I’ve tried
If me![myfield] = 0 then
Me![myfield].forecolor = 255
End if
On the load, open and current event of the sub form, but all it succeeds in doing is (if the first field is = to 0) to turn [myfield] in all of the records to red, not just in the record where [myfield] = 0

Can anyone help with this?

Regards

Eddie

 

[pbaldy]

If you have Access 2000 or later, conditional formatting would be the easiest way to achieve this.

 

[Eddie Mason]

Hi Paul,

Many thanks for the advice, Its the first time i've heard about conditional formatting, it really is useful.

kind regards

Eddie