[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Access Report subform doesn't show/apper in paper

Posted on 2009-02-11
Medium Priority
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
Question by:pancho_alvarez
LVL 33

Accepted Solution

jppinto earned 750 total points
ID: 23609961
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.


Author Comment

ID: 23610712
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.


Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question