Reports conditional formatting

[deb]

I am using Access 2k.
Is it possible to have the name field turn red if the status field is "Closed", using conditional formatting?

It seems to only work if you are using the condition on one field and that fielld is numeric.

Thanks in advance,

 

[SydneyGeek]

I haven't used the conditional formatting feature much in Access -- I tend to use the OnFormat event for the report section. Try this:

1. Go into design view on the report. Right-click the Detail band, select Properties, and go to the OnFormat event.
2. Click the Builder (...) and select Code from the popup.
3. You should be in Private Sub Detail_Format
4. Try this code:

If [Status]="Closed" Then
  [Name].BackColor=255 'red
Else
  [Name].BackColor=16777215 'white
End If

HTH
Denis

 

[deb]

Thank you,

It works beautifully!! :idea: