Multiple-page forms

[EAS]

When using multiple-page form, are you still constrained to the 22 logical
inches high? I'm trying to create an input form that mimics a 13-page form
that uses multiple tables. Still trying to decide if one form with page
breaks will work (would likely outscale the 22" if that's a hard stop) or
figuring out Tab Control formatting.

 

[Jeanette Cunningham]

Hi EAS,
A tab control works by allowing you to spread the text boxes and combos etc
across several 'pages' of a tab control.
If you wish to avoid learning about tab controls at the moment, there is an
alternative.
You can use a main form with a list box down the left side and a subform on
the main form.
Break up your super-long-many-scrolls-required form into several smaller
forms.
Put the names of those smaller forms into a query that is the row source of
the listbox.
Use the after update event of the listbox to change the source object of the
subform control to whichever form is the correct one for the value the user
selects in the listbox.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia