| | |
|
|
|
reports in access 97 |
|---|
| message from MStrider on 19 May 2004 |
how the hell do I change the back colour of a textbox on the fly using vba?
I am trying this, but the property of backcolour doesn't seem to work in
reports
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.mailer_number) Then
Me.TXT_mmail = ""
Me.TXT_mmail.backcolor = RGB(0, 0, 0) - this bit doesn't work
Else
Me.TXT_mmail = "MMAIL"
Me.TXT_mmail.backcolor = RGB(255, 255, 255) - this bit doesn't work
End If
End Sub
Thanks for your help!
|
| TC replied to MStrider on 20 May 2004 |
Set the BackStyle (or whatever it's called) property of the textbox, to
Solid.
HTH,
TC
"MStrider" <MStrider@nospam.com> wrote in message
news:#qvMKFbPEHA.1036@TK2MSFTNGP09.phx.gbl...
|
| M Skabialka replied to MStrider on 19 May 2004 |
Here's an example that works on one of my reports.
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If Me!ErrorCheck = True Then
Me!ErrorCheckProjectNumber.ForeColor = 255 'red
Else
Me!ErrorCheckProjectNumber.ForeColor = 0 'black
End If
End Sub
"MStrider" <MStrider@nospam.com> wrote in message
news:%23qvMKFbPEHA.1036@TK2MSFTNGP09.phx.gbl...
|
|
Archived message: reports in access 97 (MS Access Forms)
