Continuous Form & Current Record

[aaron.orrell]

I would like to be able to alter the color of the currently selected record in a continuous form.

Has anyone done this before or can offer any suggestions?

 

[smallh]

The only way that I have found to do it is place a transparent field over the top of the original and have an iif condition within the field as a control source. This will then display the specific field in a different color

Example iif statement:

=IIf([FF By When]<Now() And IsDate([FF Sign Off])=False,[FF By When],"")

 

[aaron.orrell]

The only way that I have found to do it is place a transparent field over the top of the original and have an iif condition within the field as a control source. This will then display the specific field in a different color

Example iif statement:

=IIf([FF By When]<Now() And IsDate([FF Sign Off])=False,[FF By When],"")

Thanks for the information smallh. I will consider how I can implement that idea.

Kind regards,
Aaron