Results 1 to 4 of 4
  1. #1
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328

    Hiding controls

    On certain forms & reports, I like to block the view several controls at once with a rectangle or a text box-it simplifies the form for the user. It also means I don't have to put in a bunch of Control.visible=true or false statements, but just one for the hider. When certain controls change values or buttons clicked, the rectangle uncovers and makes those controls available.



    I am seeing, to me, a weird phenomena. On a columnar form, the top control only in the list always shows through the rectangle. Send to back, front doesn't affect it, it just shows. I found this true in a2003 with XP and a2007 with W7. Any ideas?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Does that control have focus?
    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
    gg80 is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Posts
    328
    That's it-thanks much for quick solution. Not sure how I got away with it before, I must have set focus on some other control not under the "blanket".

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2007
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    This works to hide the controls but controls are still enabled and available to user. If these are data entry controls and they tab or enter to advance to next control they will still have to tab through them unless you have TabStop property set to No on ALL data entry controls. I think is more confusing and annoying to user. That's why I rejected the idea of a 'blanket' on my forms and use individual code statements to set properties of controls - Enabled, Visible, TabStop, Locked, ControlSource, BackStyle, BackColor. More work for me but only have to do it once and friendlier for user.
    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.

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

Similar Threads

  1. Hiding toolbar?
    By BAX5127 in forum Access
    Replies: 2
    Last Post: 04-06-2011, 10:58 AM
  2. Hiding The Ribbon
    By rashidhussain in forum Forms
    Replies: 1
    Last Post: 03-01-2011, 03:36 AM
  3. Hiding Macro
    By datacase in forum Access
    Replies: 3
    Last Post: 01-07-2011, 08:41 AM
  4. Hiding subreports
    By aouellette in forum Reports
    Replies: 0
    Last Post: 09-12-2008, 08:02 AM
  5. hiding forms
    By Halocarbon in forum Access
    Replies: 1
    Last Post: 12-09-2005, 09:51 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