|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 28th, 2005, 05:26 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Create a report so it shows me the details sections in alternate c
Hi
I'd like to create a banded report - grey white, grey white etc. Do I need to do this in VBA? Any help greatly appreciated Thanks in advance Grd 
|
|
#2
November 28th, 2005, 05:33 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Create a report so it shows me the details sections in alternate c
1. Add a text box to your report, and set these properties:
Control Source: =1 Running Sum: Over Group Visible: No Name: txtCount Format: General Number 2. Add another text box to the report. Make it the entire size of the (Detail?) section. Place it behind the other controls: Format | Send To Back. 3. With this box selected, choose Conditional Formatting on the Format menu. Set the conditional formatting to: Expression ([txtCount] Mod 2) = 1 and choose the color you want from the bucket. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Grd" wrote in message ... Hi I'd like to create a banded report - grey white, grey white etc. Do I need to do this in VBA? Any help greatly appreciated Thanks in advance Grd
|
|
#3
November 28th, 2005, 09:14 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Create a report so it shows me the details sections in alterna
that works great
Thanks Grd "Allen Browne" wrote: 1. Add a text box to your report, and set these properties: Control Source: =1 Running Sum: Over Group Visible: No Name: txtCount Format: General Number 2. Add another text box to the report. Make it the entire size of the (Detail?) section. Place it behind the other controls: Format | Send To Back. 3. With this box selected, choose Conditional Formatting on the Format menu. Set the conditional formatting to: Expression ([txtCount] Mod 2) = 1 and choose the color you want from the bucket. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Grd" wrote in message ... Hi I'd like to create a banded report - grey white, grey white etc. Do I need to do this in VBA? Any help greatly appreciated Thanks in advance Grd
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Report shows alternate blank pages | Howard | Setting Up & Running Reports | 1 | October 15th, 2005 12:52 AM |
| Printing Reports Access 2002 Pleas Advise | Dermot | Database Design | 12 | October 5th, 2005 11:23 AM |
| Exporting Report To Excel | PK | Setting Up & Running Reports | 0 | October 4th, 2005 03:49 PM |
| create report for e-mails | Robert Blackwell | General Discussion | 1 | March 7th, 2005 09:22 PM |
| Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Linear Mode
