limiting viewable columns in datasheet view

[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

 

[Guest]

Open the form in design view and delete the controls for the fields you don't
want to include.

 

[ChasW]

Open the form in design view and delete the controls for the fields you don't
want to include.

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.

 

[Guest]

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.

 

[ChasW]

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

This was just what I needed.
Thank you!
Chas