Report formatting

[Christopherusly]

ok, what i would like to be able to produce is a report in which every other row has a grey background, so you would have a report in which you had

Grey row [information here]
White row [information here]
Grey row [information here]

and so on, i am told this is possible in crystal reports, but no one seems to know if this is possible in access, has anyone any suggestions ?

Any help is appreciated

Christopherusly

 

[llkhoutx]

In the report module declaration add:

dim fShade as boolean

The OnPrint event property of the report should have the following code:

Private sub Detail1_Print(cancel as integer, Printcount as Integer)
const acbccolorGray = 14540253
if fShade then
me.detail1.backcolor - acbcColorGray
else
me.detail1.backcolor = vbwhite
end if
fShade = Not fShade
end sun

 

[mresann]

Start with this:

Alternate Row Color in Access Report

 

[Christopherusly]

that is super fantastic guys thank you very much indeed