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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top