Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 711
  • Last Modified:

Access 2010 Report -- Displaywhen = 2 --- not as expected

Hi
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.
0
peispud
Asked:
peispud
  • 2
  • 2
1 Solution
 
hnasrCommented:
You may need 2 reports, one for screen display the other for printer.

IF more help is needed attach a sample database showing the problem.
0
 
peispudAuthor Commented:
Respecfully,   I have trouble with that.

First of all,  perhaps there is an event before printing where I could reduce the width of the hidden columns to zero (and then restore them after the print job).

I have trouble with that. It doesn't make sense to me that you that the displaywhen property is left orphaned (in a report) as this suggests.  If someone thought of this command for the screen, then I expect that the thought would have extended to printer output.
  I do appreciate your input though.  Please don't consider my disagreement  as a sign of disrespect.
0
 
als315Commented:
I prefer 2 reports, as hnasr was suggested, but you can of course create dynamic reports. Here you can find examples:
http://bytes.com/topic/access/insights/696050-create-dynamic-report-using-vba
0
 
hnasrCommented:
My second comment was not addressed.
"IF more help is needed attach a sample database showing the problem."
0
 
peispudAuthor Commented:
Thanks..  

I have reconsidered my approach and listened to your advice, but you did give me a fine answer.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now