Subreport not printing but showing in preview, or not showing at all 
Author Message
 Subreport not printing but showing in preview, or not showing at all

I recently workarounded this issue that has been a headache for a while.

As I know some people in this forum has had the same problem (and maybe
still having), I post this to try to help them in the future. The problem
for the subreport not to show up in preview or to show in preview but
"dissapear" when printing seems not to be a bug of Access 2000 (as many of
us thought) but a matter of calling the data source. If we change the data
source of the subreport for the equivalent SQL statement, "SELECT * FROM
TABLE1" instead of writting down the name of the table directly, it will
workaround the problem.

Best regards.


Sat, 13 Aug 2005 04:09:29 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Show/not show a subreport base on a value of subreport field

2. printing form not showing in print/print preview

3. Actual prints (labels) not printing as shown on the print preview screen

4. Bottom page border not showing in print preview or printing

5. Text not printing but it shows up in print preview

6. Subreport does not print from preview, prints perfectly from VBA: Print,,acNormal

7. Default Print Preview Toolbar does not show!!!

8. Created Forms will Not Print or Show in Preview

9. Forms show labels/fields in design view, not in data entry or print preview views

10. Print Preview does not show all text in excel chart - why

Powered by phpBB® Forum Software © phpBB Group