Results 1 to 2 of 2
  1. 11-17-2011, 10:47 PM #1
    stevepcne
    stevepcne is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2011
    Location
    Boston, Ma.
    Posts
    23

    show / hide columns based on criteria?


    Hi, Does anyone know if I can show/hide columns based on criteria,nulls,or conditional formatting? Thanks...
    Reply With Quote Reply With Quote
  2. 11-18-2011, 02:49 PM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,899
    Not directly with tables or queries. You can use VBA code behind form or report to hide controls.
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Show sum based on criteria, but show all rows independent of criteria
    By AccessTheBase in forum Queries
    Replies: 1
    Last Post: 06-12-2011, 07:08 AM
  2. Hide/Show Columns based on DropDown Selection in Form
    By taya621 in forum Access
    Replies: 6
    Last Post: 02-24-2011, 03:24 PM
  3. Hide and show tekstbox
    By Patience in forum Access
    Replies: 3
    Last Post: 06-18-2010, 06:15 AM
  4. Show/Hide Columns in a Query
    By SCFM in forum Access
    Replies: 1
    Last Post: 02-23-2010, 08:04 AM
  5. Hide & unhide subform based on criteria of combo on main form
    By KLynch0803 in forum Forms
    Replies: 6
    Last Post: 06-03-2009, 02:01 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums