Can I freeze columns in a form/subform?

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

Guest

I am building a database to use for some reporting. The problem is that the
information I need to display takes up more width than what can be displayed
on one page. I need to be able to scroll across the subform, but still have
the first column's data visible.

Any thoughts?
 
Try this stages:

1. Open the SubForm separately (without the main form)
2. select the column you want to freeze (click on top)
3. In the toolbar select Design > Freeze column

Close the sub form, you will be prompt if you want to save the changes,
select Yes
Now open the main form and try
 
If there are multiple subforms on a form, then the user/you will need
to change one subform at a time and close the form between each subform
change.

If you use Cohen's method, in a sense you have done this already (one
subform at a time).
 
The user or you can do this also when the form (and subforms) are
opened for use. Right click on the column you want on the left hand
side and select freeze column.

If you do it as the developer to the FE before distributing it then all
users will see the freeze. If they do it on their version then each
will have it depending on what they froze, BUT when they get a new copy
of the FE then whatever you last set it to will be what they see.
 
Back
Top