Changing Record Color in a Report (Conditional) 1

[Hayton]

Good Morning Everyone,

I have a report which is based on a table/query. In the table I have a check box. If I select the check box, I would like that record to appear in red on the report.

I have tried conditional formatting and some vba and can't get it to work for a single record, it formats the whole sheet (All the records)

Any Ideas?
Thanx

 

[JohnLowell]

You need to build an if statement in the detail format event.

If <condition> then
me.detail.backcolor = ### ' desired color
else
me.detail.backcolor = #### ' default color
endif

 

[Hayton]

Hi John, thanks for the code. Is there a way that we could make it highlight the text and not the background of the report.

Thanks

 

[MichaelRed]

Yes, but it is a bit more work. It is essientially a loop within the (already given) conditional. The loop is (approximatly):

[tab]For each Ctrl in Me.Detail.Controls
[tab][tab]Ctrl.ForeColor = <desired color.
[tab]Next Ctrl

Not that &quot;Ctrl&quot; must be declared as control. Depending on some details, you may need to check the control type and skip any where there is no &quot;ForeaColor&quot;.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over