We help IT Professionals succeed at work.

Access Report subform doesn't show/apper in paper

Medium Priority
317 Views
Last Modified: 2013-11-28
  I have an Access 2003 report that  has an embedded subform whose source object is an access 2003 Query (i.e. uspRptActividadesINPrev). When I see the report in its preview form the subform shows the data I want, however, if I send it to the printer in order to obtain a paper-based copy of it, the subform data is not printed and a blank space is shown in its place. I cannot seem to find the problem, thus, I will appreciate your help.

   I have attached a JPG file showing the subform data in the report's preview form that doesn't appear in the printed one.

Best Regards
Francisco
SubformInReport.jpg
Comment
Watch Question

Commented:
Checj the page setup of your report. Maybe the subreport width is greater than the width of your report or paper definition. Try this: decrease the width of your report on Report design to half the size and without saving the report, run the report to see if it appears on paper.

jppinto

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Hello jppinto,
                        You were almost right when you suggested that it was something about the width of the REPORT. Originally the report was developed in an Access 2000 database with a then I converted the Access 2000 database into an Access 2002-2003 one. I just modified on the "page setup" option the size of the page from LETTER -which appears to be the default option in Access 2003- to A4 -European standard- and that fixied the problem.
                        The points are yours anyways.

Thanks
Francisco
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.