No Print Certain Fields

[Bob]

Hello all. I am doing a report that has to serve two groups of people.. On
report has to have all fields and the on is the same report but with less
fields..

My question is if I can keep the same report but in one not print some of
the fields..

I hope that I am explaining this well enough.

Thanks for your help in advance..

Bob

 

[Jeff Boyce]

Yes.

You can hide a control or a section by setting its .Visible property to No
in the report's OnFormat event.

.... but you'll need to give Access some way to know when to show/hide either
the individual controls or entire sections.

Your code in the OnFormat event needs to "know" which group ordered the
report before it can set that property.

Regards

Jeff Boyce
Microsoft Office/Access MVP