Printing Sub Reports in Access

[dimpie]

Hi - I have 2 sub reports included in one main report. Two sub reports run on
different queries.

In the Print Preview of the main report, it is fine. But when i try to print
on a printer, it prints a blank page.

Please HELP!!!!!

Really appreciate your time.

Thanks.

 

[NetworkTrade]

are you able to sanity check and compare behavior on a different PC/printer?

 

[dimpie]

Ya i have tried printing on 2 diff printers and also a Pdf writer. Non works.

Any ideas Please!!

 

[NetworkTrade]

you are saying that one of the subreports shows data on screen; but is blank
when printed?

or are you saying that there is a blank page appended to the end of the
report when printed?

 

[dimpie]

Both the subreports have data in Print Preview mode. But when i have to
print, then it prints a blank page.

There is no data printer by the printer ever though i see data in the print
prview mode

Thanks!!

 

[NetworkTrade]

no one else has jumped in with another idea....sometimes the MVPers only look
at new posts - so you might need to report this one because I don't know.
Generally very odd behavior in a report can be caused by the printer driver.
You state you tried different printers; but you did not explicitly state you
tried different PCs...be sure to try different PCs....

sub reports won't appear if there is no data. but they will not appear on
screen either....so if it is not this then generally it would be the printer
driver

the only other thing I think of is whether someone embedded a little VBA to
make those subreports not visible when printed...possibly as a mild security
thing...but if you are the author then that isn't viable....