Change Report Label Color If?

[Dave Elliott]

Why wont this code work? It is supposed to change the label red if the label
says Past Due???
I tried it on the open event for the report. As well as the code that opens
the report.

If Reports!InvoiceReport!QuoteInvLabel.Caption = "Past Due" Then
QuoteInvLabel.ForeColor = vbRed
End If


Thanks,

Dave

 

[Roger Carlson]

Try the OnLoad event.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Dave Elliott]

Ther is no onLoadEvent for a report.

Try the OnLoad event.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L