Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Got some valuable lessons here regarding groups. Beyond but including the issue in this thread, I broke the Detail section of the report into multiple groups. There are a variety of controls in each group, including labels, text boxes and sub-report containers. Each group has the controls inserted into its Header section except the last which has its controls in the Footer section. The app includes a user interface to user settings where the user can stipulate with a check-box the inclusion or exclusion of the last group described herein. The OnActivate event of the report interrogates that setting and sets the visibility of the last section's visibility accordingly.



    As discussed earlier in this thread, I did not but it would be a simple matter to table all the calculated values and bind the otherwise unbound text boxes to those fields.

    My thanks to HiTechCoach for sharing "The Trick".
    Bill

  2. #17
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Bill,

    You're welcome.

    Great to see you learning some new tricks.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. pulling portions of data
    By mike02 in forum Queries
    Replies: 2
    Last Post: 08-02-2012, 02:22 PM
  2. Suppressing records in a report
    By snowboarder234 in forum Reports
    Replies: 1
    Last Post: 07-11-2012, 07:52 PM
  3. Suppressing Access messages
    By Reaper in forum Forms
    Replies: 1
    Last Post: 11-06-2011, 04:02 PM
  4. Suppressing a msgbox
    By alphabetsoup in forum Forms
    Replies: 3
    Last Post: 10-04-2011, 10:30 AM
  5. Suppressing #Name? Error
    By Jess_Wundring in forum Programming
    Replies: 2
    Last Post: 04-15-2010, 12:43 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