How to keep Datasheet Columns Hidden

[Tash]

Hello -

I have a datasheet that contains multiple fields/columns, and these fields also contain calculations and expressions. The problem that I am having, is that I want to hide most of these fields for the user when they open up the datasheet, however, no matter what I have tried, the columns just pop back up again once you open it.

I have tried to set the individual field properties to not visible, unclicked the checkboxes in the Unhide... menu option and saved the entire datasheet hoping to keep these settings. Does anyone have any suggestions? Is there something that I am missing? I have used the Unhide option before, and it has worked, but for some reason (maybe the multiple field references or something) it is not working for this datasheet.

Thank you!

 

[mac318]

Dim dbs As Database, tdfCustomers As TableDef
Set dbs = CurrentDb
Set tdfCustomers = dbs![Customers]
SetFieldProperty tdfCustomers![Address], "ColumnWidth", dbInteger, 0