Conditional Formatting in Access Reports?

G Marshall

Board Regular
Joined
Dec 31, 2002
Messages
134
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.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

bmacr

Board Regular
Joined
Jan 14, 2004
Messages
94
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,232
Messages
5,594,956
Members
413,954
Latest member
mrsandy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top