Hide column in datasheetview

  • Thread starter Thread starter rum23
  • Start date Start date
R

rum23

I want to hide a control in the subform which is a datasheet and can't find
where this setting is. Can somebody help? I am using ACCESS 2007.

I tried selecting the control and then right click. The right click popup
menu doesn't have it. Where is the "hide column" setting hidden?

Thanks much
 
Try dragging the column to the left like doing a spreadsheet, then save.
That will set the column width to zero (0). Alternatively, you can open the
form in Design View, select the field and set its Visible property to zero
(0) in the property sheet.
 
Did you select the column when displayed as data sheet? By this I mean did
you click in the title part of the column thus highlighting the whole column?
I can hide columns by right clicking the title when the whole column is
selected.
 
I don't see "hide column" in the right click popup menu, no matter what I
select. I have tried, column only, the title part of the column, both
selected, etc but nothing seems to bring the "Hide column" property for me.

I ended up setting the "ColumnHidden" property to true on Form_Load() event.
That seems to be working.

Thanks for all the input.
 
Back
Top