Colour formatting with spacific colours

  • Thread starter Thread starter Derek Brown
  • Start date Start date
D

Derek Brown

Hi all

Can I have access format the back colour of a field on a report by the
number that access uses to represent the colour. I have a report that needs
pastel colours to indicate different tasks. The colours in conditional
format are to bold making some text hard to read..
 
Thanks Steve

Perhaps you did not get my original question or more likely I've missed
something. The link to the formatting was showing form views I need
formatting for reports. Any ideas??

Just installed your calandar Mod brilliant.
 
Same code just a different event from Forms to Reports. Try the relevant
section's Format event.
I would be interested in how you make out. Let me know

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
If you'll look into Stephen's (NOT Steve) suggestion more
closely, you'll see that it will work in report's too.

OTOH, there are easier ways to do this kind of thing in a
report than in a continuoud form. Just use VBA code in the
Detail(?) section's Format event to set the text box's
BackColor property to the desired rgb value. E.g.

If Me.text1 > 99 Then
Me.text2 = RGB(255, 192, 192) ' Pink
Else
Me.text2 = vbWhite
End If
 
Back
Top