Access Report subform doesn't show/apper in paper

Posted on 2009-02-11
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

    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

    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

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now