Conditional Formatting Urgent HELP!!!!

[bronen]

I have a text box on a report that pulls values from a table: Blue, Red, Green, Gold, Yellow, Purple, and White.

The report is supposed to have the background behind each word be that color. IF the data has the color Blue, then the background color behind that word should be Blue as well. I have the following code

if PreviousStatus = Blue Then
PreviousStatus.BackColor = 16711860

As an example for blue. I have also tried:

Select Case Me.PreviousStatus.Value
Case "Blue"
Me.PreviousStatus.BackColor = 16711680
Case "Green"
Me.PreviousStatus.BackColor = RGB(0, 255, 0)
Case "Red"
Me.PreviousStatus.BackColor = RGB(255, 0, 0)
Case Else
Me.PreviousStatus.BackColor = vbWhite
End Select

Why is it wrong? Why am I not getting color to show up?

 

[SoCalAccessPro]

What is the previousstatus property ? Is it user defined ? I'm not familiar with ever using that property.

Tyrone Lumley
SoCalAccessPro

http://www.socalaccesspro.com

 

[MichaelRed]

try the actual conditional formatting (menu option)?



MichaelRed

 

[dhookom]

Is the control set to transparent?

Duane
Hook'D on Access
MS Access MVP