limiting viewable columns in datasheet view

  • Thread starter Thread starter ChasW
  • Start date Start date
C

ChasW

I have a form that allows a datasheet view and a form view of a query.

Is it possible to limit the viewable columns in the datasheet view?

Right now, in addition to the columns I want, I am also getting some
text box names like Text36, etc.

Thanks for any tips or suggestions.
Chas
 
Open the form in design view and delete the controls for the fields you don't
want to include.
 
Open the form in design view and delete the controls for the fields you don't
want to include.
Click to expand...

I want ALL of the controls included in the form view, so if i delete
anything, I will be breaking the form, won't I?

I am seeking to limit what is viewable only in the dataset view of a
given query subform.
 
True, but you did not make that clear in your original post or I did not
understand correctly.

Look up the ColumnHidden property in VBA Help. I think it will get you what
you need.
 
Back
Top