Create a report so it shows me the details sections in alternate c

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
that works great

Thanks
Grd

Allen Browne said:
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.

Reply to group, rather than allenbrowne at mvps dot org.

Grd said:
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
Click to expand...
Click to expand...
 
Back
Top