Freeze pane (Like in Excel)

[Guest]

Good afternoon,

I've been asked by my co-worker if there is a way to freeze the first two
columns in a form, so that they are always visible when they scroll. They
used the obvious comparison with Excel's freeze pane.

Can this be done and how?

Thank you,

Daniel

 

[fredg]

Good afternoon,

I've been asked by my co-worker if there is a way to freeze the first two
columns in a form, so that they are always visible when they scroll. They
used the obvious comparison with Excel's freeze pane.

Can this be done and how?

Thank you,

Daniel

In Form Datasheet View?
Open the Form in Datasheet View.
Select the 2 columns.
Click Format + Freeze Columns

 

[Guest]

Can this be done in 'continuous form' format?

 

[fredg]

Can this be done in 'continuous form' format?

Not as far as I know.

 

[Guest]

This is a guess but:

If you reformated the form on the fly, such that the data selected to be
continuously displayed was moved to the form header, with the rest in the
detail section you should get the same affect. You may have to have the form
setup as mainform/subform, so you can have two record sources.

Dave

 

[Arvin Meyer [MVP]]

You can Freeze columns in Access in the same way they can be done in Excel.
Select the columns to be frozen and go to the Format menu and choose Freeze
Columns.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access