Results 1 to 6 of 6
  1. #1
    khayward is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Apr 2017
    Location
    Oregon
    Posts
    89

    Subreport name appears at top of subreport in print preview

    I've done a bit of searching around for an answer, but everyone seems to have problems with subreports not showing up at all. My subreport shows up just fine, exactly how I want it to, but when I go to print it the name of the subreport appears in the top left corner of the subreport area as shown in this image. It doesn't appear to be tied to the Caption property, as I have played with that already. This does not appear in layout view, report view or design view, just when I go to print, so in print preview and on the printed report. Any ideas?


    Click image for larger version. 

Name:	subreport name picture.PNG 
Views:	16 
Size:	5.3 KB 
ID:	40482

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Never seen this. Can only suggest you try from a different computer. If you want to provide db, will try for you.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    khayward is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Apr 2017
    Location
    Oregon
    Posts
    89
    BCMRP1.zipThanks for the tip - I tried opening it on another computer and still had the text show up in print preview, and it also shows on the printed report. I've attached the db, the report uses some form data, so if you open a form called 'frmAssemblies', then navigate to the second record and click the button labeled 'Generate Quote' the report will open up in the same manner that I am seeing it. As I said, the blue text doesn't show up in design or layout view. I suppose it's possible there's a label control that's somewhere I can't see it. I do appreciate your advice and help, thank you!

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I got an 'inconsistent state' error when opening db but seemed to recover okay.

    Subreport container control has an associated label sitting behind it. Label name is "tblTandCtoCustomer subreport Label". Select it from PropertiesSheet dropdown and delete it.

    Interesting it does not display in ReportView.




    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    khayward is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Apr 2017
    Location
    Oregon
    Posts
    89
    Quote Originally Posted by June7 View Post
    I got an 'inconsistent state' error when opening db but seemed to recover okay.

    Subreport container control has an associated label sitting behind it. Label name is "tblTandCtoCustomer subreport Label". Select it from PropertiesSheet dropdown and delete it.

    Interesting it does not display in ReportView.




    Thank you for looking at it! I thought it might be something of that nature. Apologies for the inconsistent state, it must have been open when I saved and zipped it.

    Thank you again for your help!

  6. #6
    LJL is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2024
    Posts
    1

    Years later, thank you....

    Quote Originally Posted by June7 View Post
    I got an 'inconsistent state' error when opening db but seemed to recover okay.

    Subreport container control has an associated label sitting behind it. Label name is "tblTandCtoCustomer subreport Label". Select it from PropertiesSheet dropdown and delete it.

    Interesting it does not display in ReportView.





    I spent an hour looking for why this was happening. I even moved the control speculating the same thing, but I could not find it. After your message, however, I became more insistent, and found it. I have to say, it was definitely not easy to find - had to select the control from the side of the frame to see the label versus just clicking on the control directly.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 08-07-2017, 08:09 AM
  2. Replies: 1
    Last Post: 12-07-2015, 07:46 PM
  3. Replies: 5
    Last Post: 08-06-2015, 03:26 PM
  4. Replies: 2
    Last Post: 03-09-2015, 01:06 PM
  5. Replies: 1
    Last Post: 01-10-2011, 01:08 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums