Conditional Formatting in Access Reports?

[G Marshall]

Hello

I have a report that shows fuel consumption in litres for various sites. In some instances this figure can be a minus figure. Is there any way in an Access Report to highlight the minus figure by displaying the font in red.
Something similar to the "Conditional Formatting" facility in "Excel".

Appreciate any advice

Cheers

Gerald Marshall

Give a Man a Fish,feed him for a day. Teach a man to Fish, feed him for life.

 

[bmacr]

In Access 2000 or newer you can use Conditional Formatting in the Format menu, otherwise the following code should work.

In the "Format" event of the DETAIL section of your report, put something like:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.YourFieldName < 0 Then
Me.YourTextBox.ForeColor = vbRed
Else
Me.YourTextBox.ForeColor = vbBlack
End If
End Sub

 

[G Marshall]

Hi there

Thanks for that info. Much appreciated

Cheers

Gerald