Are you so phuqing lazy you didn't even bother looking at the
properties of a text box, or are you just stupid?
Me![Cat No.].ForeColor = wbWhite
feeman wrote:
Quote:
A while back I asked about changing the background colour of a text box
according to the outcome of a tick box, and the code below was supplied
which worked very well.
>
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me![O/S] = -1 Then
Me![Cat No].BackColor = vbYellow
Else
Me![Cat No].BackColor = wbWhite
End If
>
>
End Sub
>
But now is all I want it to do is change the colour of outstanding to
yellow, but change the font to white, so that when printed stands out a
little more, especially due to the fact that work has decided to reset
all the printer to black and wjite so when using a darker colour you
can not see the text.
