By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 1,592 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

fill colour in report

P: n/a
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.

Aug 11 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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:
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.
Aug 11 '06 #2

P: n/a
On 11 Aug 2006 12:27:30 -0700, "ManningFan" <ma********@gmail.com>
wrote:
>Are you so phuqing lazy you didn't even bother looking at the
properties of a text box, or are you just stupid?
It would be very cool if you stopped posting crap like this. This
newsgroup would be a lot more pleasant to read.

Aug 11 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.