How do you Hide a Column of data in a Data Grid?

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • nikhilnangia1
    New Member
    • Jan 2010
    • 1
    #1

    How do you Hide a Column of data in a Data Grid?

    How do you Hide a Column of data in a Data Grid in Access 2007 using VBA code?

    Please help me. This is urgent
    Last edited by NeoPa; Jan 30 '10, 11:10 PM. Reason: Removed plzzzzz help me text
    Tags: None
    • nico5038
      Recognized Expert Specialist
      • Nov 2006
      • 3080
      #2
      Assuming the datagrid is a subform named "sfrmEmploy ee" you can use this code behind a button on the main form:
      Code:
      Me.sfrmEmployee.Form!ID.ColumnHidden = Not (Me.sfrmEmployee.Form!ID.ColumnHidden)
Me.Requery
      to toggle the column "ID" from hidden to visible and vise versa...

      Nic;o)

        Comment

        • NeoPa
          Recognized Expert Moderator MVP
          • Oct 2006
          • 32633
          #3
          Originally posted by nikhilnangia1
          plzzzzz help me
          Please read our posting rules, available from every page of this site at top-right under Help. This is not acceptable and will not win you friends.

          As to your question, it would help us to help you if you were a little more clear in what you're actually asking for. Is this data within a table grid? Is it a query? What.

            Comment

            Previous template Next
            Working...