473,322 Members | 1,778 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Conditional Formatting for a Report

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?
Nov 9 '10 #1

✓ answered by 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:
Expand|Select|Wrap|Line Numbers
  1. Name: txtBold
  2. Control Source: =1
  3. Visible: (Yes or No)
  4. 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

4 1232
gnawoncents
214 100+
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:
Expand|Select|Wrap|Line Numbers
  1. Name: txtBold
  2. Control Source: =1
  3. Visible: (Yes or No)
  4. 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
Nov 9 '10 #2
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?
Nov 10 '10 #3
BTW Gnawoncents, that worked perfectly on my report, just wondering if there's a way to do something similar on a form?
Nov 10 '10 #4
gnawoncents
214 100+
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?
Nov 10 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Majstor | last post by:
Is it possible to make conditional formatting in report? Thanks. Mario.
2
by: Von Bailey | last post by:
I have a form where the conditional formatting is set on some fields to bold if certain conditions are met. However, when the conditions are met some of the data that is to bold is either not...
3
by: Chuck Reed | last post by:
I am working on a sales report where I show weekly sales by category for each of the 52 weeks in the year. Each record in my table/report has the 52 weeks of sales in it. I want to highlight to top...
5
by: Andrew Chanter | last post by:
Does anyone know a way you can use conditional formatting to create a banded style view as is commonly seen on the internet. (In othe words the first record appears on a gray background, the 2nd...
1
by: DavidB | last post by:
I have a report that (among other data) lists three different date fields from one of my tables. This is a validation report in that date #1 and date #2 should be earlier than date #3. The report...
2
by: enywu | last post by:
Hi all, I have created a report in my access database through a query. The report has no problem, however now there is new request that they want this report to use the conditional formatting....
4
by: riaane | last post by:
Please help: I have Conditional Formatting on a Report Field that fills the background Red if the criteria is met. This displays correctly in Report View, however, when I "OutputTo" this report to...
5
by: Whizzo | last post by:
Hi all; Any reason why putting: Len()<Len() into the Conditional Formatting of a control isn't applying it in a report? Even when the length of is indeed shorter that the length of ? I've...
5
by: Desitech | last post by:
I have a Label on a report with a check box from a table indicating True or False. I would like to have the labels that are true to highlight yellow using conditional foramtting. The False labels to...
2
by: emckesso | last post by:
Hello, I need to create conditional formatting of a text box in the detail section of a report. The formatting is based on multiple parameters that are stored in a query. For example, pretend...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.