I am using Access 2010 ----- Report
I have designed a report with 10 fields. Five of them have been set with the property
DisplayWhen = 2.
So, the affected fields are viewable on screen but dissappear when printing. This is fine except that the space used by these fields still contributes to the page width.
This results in 5 columns of visible data that are squeezed into the left side of my printed page. The right side of the page has 5 fields that are invisible but occupy space. This forces me to use lanscape instead of portrait printouts.
I would like those 5 invisible fields to occupy zero space at print time. I appreciate your help.