Freeze pane (Like in Excel)

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

In Form Datasheet View?
Open the Form in Datasheet View.
Select the 2 columns.
Click Format + Freeze Columns
 
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
 
Back
Top