Alternate shading

[LMB]

Hi,

I have a crosstab query that the users open up to view. It would be much easier to read if every other line were shaded. Is there anyway to do this?

Access 2000

Thanks,
Linda

 

[Allen Browne]

Only in a report.

You can use Conditional Formatting to shade a text box behind the detail
section.

You can determine the even lines with another text box that has these
properties:
Control Source =1
Running Sum Over Group
Name txtCount
Format General Number
Visible No

Then use an Expression in the Condition format of your grey text box:
[txtCount] Mod 2 = 0

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

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

Hi,

I have a crosstab query that the users open up to view. It would be much
easier to read if every other line were shaded. Is there anyway to do this?

Access 2000

Thanks,
Linda

 

[LMB]

Thanks
Only in a report.

You can use Conditional Formatting to shade a text box behind the detail
section.

You can determine the even lines with another text box that has these
properties:
Control Source =1
Running Sum Over Group
Name txtCount
Format General Number
Visible No

Then use an Expression in the Condition format of your grey text box:
[txtCount] Mod 2 = 0

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

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

Hi,

I have a crosstab query that the users open up to view. It would be much
easier to read if every other line were shaded. Is there anyway to do this?

Access 2000

Thanks,
Linda