Dynamically freezing columns in a datasheet view

Topic

New Reply

Does anyone know of a way to Dynamically Freeze columns on a Form in DataSheet View

Code:

[FieldToFreeze].SetFocus
DoCmd.RunCommand acCmdFreezeColumn

It seems strange that you can set the ColumnOrder, ColumnWidth and ColumnHidden properties of a DataSheet view along with other DataSheet properties,
but the Frozen Columns can only be set using a RunCommand.

I may have missed a new property in 2010 but I don’t think so.

Reply | Quote

Replies

Here is an article from MSDN which might be of some help

http://msdn.microsoft.com/en-us/library/aa217449(office.11).aspx

Reply | Quote

Thanks.
I’d had a look at that, and although it uses a Macro for freezing columns, it still relies in focus.
It would appear that in all those properties and methods, there are none that allow manipulation of frozen columns.
Pretty much everything else.
You wonder what the object model was to prevent having a froxen column property of method.

Access 2015 then?

Reply | Quote