Forms in DataSheet View (1 Viewer)

I have a form that I display in DataSheet. You can click on different columns and to change the Order_By. (Side Note: Actually I reload the recordsource changing what I need. I don't know if there is an easier way but it works.)

When you click one column I change the group by and everything works fine I get fewer records grouped by the field I'm looking for. I wish to reduce the number of field (columns) displayed also (the ones not used). I tried to use enable=false, they dim and the columns (fields) display #Name#. However, the columns are still there.

Can someone help me with this?

I think what you're looking for is the ColumnHidden Property.

If you have ones that are never going to be used, why not base your form on a query?

Actually, they all get used. I change the grouping and sort via double-click so at different times I may not display all columns.

Sorry about not getting the ColumnHidden. I actually knew that and for some reason didn't think of it. Mental Block today and I just couldn't get it.

Thank you guys.....