Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,115
    Hi there, in the report's record source look at the last field, it is a calculated one named HideControls.

    Cheers,
    Vlad
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  2. #17
    astath is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Apr 2020
    Posts
    30
    Found it and everything works perfectly! Once again, many thanks!

  3. #18
    astath is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Apr 2020
    Posts
    30
    (Hopefully) one last question regarding your code. Is it possible to amend it in order to hide info for specific WHIDFK field values instead of empty fields? And if so what should I change in the code?

    As always, many thanks!

  4. #19
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,115
    For that no changes to the code are needed, just adjust the HideControls calculation accordingly HideControls:IIF([YourField]="YourValue","Yes","No").

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 5
    Last Post: 06-14-2016, 09:02 AM
  2. insert a powerpoint presentation into access
    By ecalvert47462 in forum Access
    Replies: 3
    Last Post: 12-04-2012, 02:09 PM
  3. Replies: 6
    Last Post: 06-25-2012, 02:57 PM
  4. Horizontal presentation
    By cacabanga in forum Access
    Replies: 4
    Last Post: 02-11-2012, 07:18 PM
  5. PivotChart presentation
    By wharting in forum Forms
    Replies: 5
    Last Post: 08-25-2011, 11:07 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