Results 1 to 3 of 3
  1. #1
    AKQTS is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    56

    Report showing non-visible fields

    I have a report where certain subreports are set to be visible or not conditionally. The fields work great, but I have to switch from report view to print view when I open the report to have to display the sub report visibility correctly. IE when I open in print view right away the non-visible fields show up, but when I switch to report view then back to print view the fields are not visible which is correct. Anyone have this problem? Thanks

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    the boolean value of the visible property might be causing it. If you have code that changes visibility based on the view, and your property sheet value is set to that same value, what you're experiencing happens.

    e.g. - prop value = true (for a control you don't want to see)

    event code:
    Code:
    me.control.visible = false
    it might be worth a try checking that out.

    it is also noteworthy to say that everytime you switch to report view, Access thinks you loaded it, just as if you double clicked on it in the db window (I'm almost positive this is true).

  3. #3
    AKQTS is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jul 2010
    Posts
    56
    Thanks, I just moved it to the Report's On Load Event, Fixed.

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

Similar Threads

  1. Report Showing ID number and not the name
    By tipopilotas in forum Reports
    Replies: 11
    Last Post: 07-20-2015, 03:21 PM
  2. fields not showing up in Form view
    By eroy in forum Forms
    Replies: 3
    Last Post: 08-28-2010, 05:44 PM
  3. Making objects visible in a report
    By Lockrin in forum Reports
    Replies: 3
    Last Post: 04-12-2010, 07:06 AM
  4. Report showing duplicate record
    By cwwaicw311 in forum Reports
    Replies: 13
    Last Post: 04-07-2010, 04:00 AM
  5. Showing Search In Report
    By Computer202 in forum Reports
    Replies: 1
    Last Post: 03-06-2010, 05:48 AM

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