Full Version: Is Freeze Pane possible in Access?
UtterAccess Forums > Microsoft® Access > Access Forms
chippyles
Is there some way to do a freeze pane like Excel has for a continuous form. I would like to freeze one or two columns on the left side of the form in order to view the right side of the form which is off the screen.
freakazeud
Hi,
Odon't think that is possible, unless you find some magic third party add in control which will let you do this.
A workaround would be to split up the data and add two subforms to your form. This way you can have the "frozen" columns in the one subform and the dynamic ones in the other!
You could also change your continoues form view to datasheet form view and then use the "Freeze Columns" command under the Format Menu.
HTH
Good luck
chippyles
This is what I thought. Thanks!!
freakazeud
You're welcome.
Glad I could assist.
Good luck on future projects!
kuifjexx
If you have the datasheet view in a form you can use the freeze columns option in the right-click shortcutmenu
reetz from Belgium compute.gif
Luc aka Kuifjexx
chippyles
Thanks, but a datasheet view is the last thing I want.
ChrisO
There is a little demo here that I think does what you require.
Hope that helps.
Regards,
Chris.
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.