Frozen Columns

[Kenln]

Is there a way to programatically change the number of columns when a form is opened?

I have a standard form/subform. With the subform (datasheet) I change it's record set, the order of the columns, which columns are hidden when the form is opened. I depends on the users initial request.

It would be great to change which columns are frozen as well.

Does anyone know how this might be accomplished?

 

[boblarson]

See if this helps:

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

 

[Kenln]

Bob, thanks again.

Took a little manipulation but it works fine.