Conditional Formatting for a Report

[FreddieIT]

Hello, I am running Access 2003 and I have a report that shows how much money is being spent per time period, for example:

10:00 am - 11:00 am = $1473.14
11:00 am - 12:00 am = $1274.21

Now I am wondering if there's a way to change the conditional format to bold the top 3 on each report. They are split up by Sections: Breakfast, Brunch, Lunch and Dinner and I want to highlight only the top dollar amounts maybe 2 or 3 of the them, is there any way of doing this?

[gnawoncents]

There is probably an easier way to do this, but the following works:

1) Create a text box and place it in line with your records

2) Set the properties as follows:

Name: txtBold
Control Source: =1
Visible: (Yes or No)
Running Sum: Over Group

3) Select the fields you want bolded and set the conditional formatting as follows:
- Select Expression Is:
- Type in [txtBold]<4
- Select Bold option

[FreddieIT]

Thank you Gnawoncents, but what if I need this to work in a form? Basically this is going to be the form master which holds all the data that everyone besides myself and another guy will need to see?

[FreddieIT]

BTW Gnawoncents, that worked perfectly on my report, just wondering if there's a way to do something similar on a form?

[gnawoncents]

Unfortunately, Access doesn't have the same feature for a form. I suppose you could base your form on a query that has a dsum field counting only the record numbers before it, but that's beyond my scope.

Anyone else?