Results 1 to 2 of 2
  1. #1
    SCFM is offline Novice
    Windows XP Access 2010 (version 14.0)
    Join Date
    Feb 2010
    Posts
    13

    Show/Hide Columns in a Query

    How can I show/hide a column in a query?. I mean i.e., I need a form with a check box for column X in a way that if I check or not the box, my query come up with column X show/hide after a click button. Thank you!

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    you can check or uncheck the visibility of a column of a query when that query is in design view.

    you can make visible or not visible a control on a form - and if that form is a continuous form then that control represents a column.

    you can create/run/open a query as vba SELECT query that varies the fields/columns that are selected.

    so there is more than one way to do this, not all are easy for a novice - it will depend on what your goal is...

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

Similar Threads

  1. Replies: 2
    Last Post: 01-13-2010, 05:29 AM
  2. Replies: 2
    Last Post: 09-26-2009, 07:19 AM
  3. Show Hide Subreport / acViewReport
    By BigBear in forum Reports
    Replies: 4
    Last Post: 03-30-2009, 06:07 AM
  4. Show/Unshow Columns in Query
    By simmurray in forum Queries
    Replies: 0
    Last Post: 03-28-2009, 10:03 AM
  5. Add Columns to query
    By 4petessake in forum Access
    Replies: 0
    Last Post: 06-15-2007, 01:38 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