Lock columns from scrolling 2

[MasterRacker]

I have a subform that has enough columns that I need to allow side to side scrolling to work with everything. I would like to lock the first few columns so they are always visible as you scroll to the right like you can do with Excel.

I thought about using a second subform to display those columns however I also have to be able to scroll vertically therefore needing to somehow sync the vertical scrolling in the second form to match the specific rows on display so I'm not sure this is a good starting point

Anyone have any pointers on how to accomplish locked columns?

_____
Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[TheAceMan1]

How are ya MasterRacker . . .

First for the subform in question you have to switch to [blue]DataSheet View[/blue]. Then its a simple matter using the [blue]FreezeColumn[/blue] method:

[blue]   Me!TextboxName1.SetFocus
   DoCmd.RunCommand acCmdFreezeColumn
   Me!TextboxName2.SetFocus
   DoCmd.RunCommand acCmdFreezeColumn[/blue]

Be aware: You loose alot of form functionality with [blue]DataSheet View![/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[MasterRacker]

Right you are about datasheet view. I had forgotten about the fact that I'm currently using a continuous form. I guess the tradeoff will be up to the customer.

Thanks.

_____
Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]