Changing .backcolor on report detail

[srmclean]

I'm struggling to change the backcolor of fields on my report.

Under Detail_Format I have a condition on the backcolor triggered by the value of a field like so :

If Me.IDDescriptionChange Then
Me.IDDescription.BackColor = vbRed
Else
Me.IDDescription.BackStyle = vbWhite
End If

I get an error when this runs, I'm told that this method or data member not found.

if I change to Me!IDDescription.BackColor then I get Object doesn't support this property or method.

Reading other posts other people seem to be able to do what I want to do but I can't get it to run.

Help?

----------------
Shaun McLean

 

[ZmrAbdulla]

You read your code again.
[tt]
If Me.IDDescriptionChange Then
Me.IDDescription.BackColor = vbRed
Else
Me.IDDescription.BackStyle = vbWhite
End If

[/tt]

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[srmclean]

Regardless, I can't change BackColor or BackStyle the issue is that I get an error message stating that the Object doesn't support this property or method. Yet other people seem to be able to execute this code on reports.

----------------
Shaun McLean

 

[ZmrAbdulla]

If you are using Access2000 or higher you can utilize Conditional formatting through the Format Menu.

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.