Freeze Columns

[Kenln]

I have a form in DataSheet view and open it if different recordsets, groups, orders etc... depending on theneed. Is there any way to freeze and/or unfreeze columns from VBA?

I have tried looking for this and cannot find it.

Any help would be appreciated

 

[gemma-the-husky]

if you cant do it in datasheet view, change to continuous forms - very similar, and you will get the control you want.

 

[Kenln]

continuous form doesn't handle nearly as well. The users here are used to Excel.

I would prefer if possible to stay with DataSheet views.

any ideas?