Okay. You know how in Excel, you can freeze some of the columns so that when you scroll, they stay put? Is there any way of duplicating that effect in Access with a continous form? My form is so wide that I can’t see the beginning when I scroll to the end. Any ideas? Again, thanks in advance.
Justin
I usually reduce the size of the form by dragging the border on the right-hand side back until the form view shows it completely.
If you were using datasheet view for your form you could use Format/Freeze Columns. With continuous forms the only thing that could be construed as “frozen” is the page & form headers and footers, which of course are vertical.
Try this tip: If your form is too big to fit all the information on one screen, use the page header to display critical information (Company name, account number, etc.) and use a tabbed control in the detail section to display the rest of the information. Group fields with similar information on the same tab.
Hope this gives you some ideas.
If you have too much data to display in the width of a gridlike view (datasheet or continuous form), you should question whether this is the right way of presenting it; if the user is constantly forced to scroll back and forth, the application will be annoying to use.
With continuous forms, you can split the data into two rows, like a sort of master and detail line, or you could make the continuous form into a subform and put some static text boxes on the main form that are populated with the extended data from the highlighted record.
I suspect I may have misunderstood the question. Or maybe not.
I have an Access database with a form containing a variable number of questions. It’s set to ‘continuous forms’, and fits on the screen by adjusting the borders in the form design.
My customer want things done a certain way, which is to emulate Excel as much as possible. This eliminates a lot of possibilities, like tabbed controls, stacking rows, etc. My solution was to use a subform in datasheet mode and frezze the columns on that. Thanks to all those who chimed in.
Justin