Length of Form

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

Guest

i have a really big form that i am creating is there a limit on how long
the form can be. im trying to add more input fields and it wont let me
scroll down any further with the scroll bar on the right does this mean i
cant go any further and it is limited to so much space?
 
How long is your form?

Why don't you use tabcontrols to make the form cleaner and smaller? I can't
imagine your users trying to find a particular control if you are making
htem scroll up several screens of space at a time.
 
Yes, but I don't know what it is but it is about 2 pages long, I would not
recommend going to more than 1 page for navigation reasons but if really
want to drag one of your controls on the form to the bottom and the page
length will increase or change the height of the detail section of the form
the max size I got is height=55.873cm

Rick's suggestion of using tabcontrols is the way forward in most cases.
 
Why not use Ctrl TAB, you can organized the data by groups, and it will be
easier for the user to use.
 
i have never used tab controls how can i find out more information on this
im not sure what you are talking about
 
The best is to just play with them. Open the properties box so you can see
what's going on. Now open the toolbox and click / drop a tab control on a
blank form. On my version of Access, the tab control is in the middle
column, second row from the bottom. Hover the mouse over it and it should
say "Tab Control."

You'll note a couple of things. There are individual tabbed "pages" (two by
default, but you can add more) --- and each has a control name. Click on
each tab to see its properties. You can set the name of each tab control as
one thing, and the wording that actually appears on the tab (Caption) as
something else --- they start out the same.

And the whole thing has a control name itself (click on the very edge of the
set of tabs to show its properties). One of the properties of the "while
thing" is how the tabs look --- whether they are "standard tabs" or buttons,
etc., whether it can exceed a single row of tabs or go onto multiple rows,
etc.

Of course, you can have controls on the form that are not on the tab ---
just on the detail section of the form itself. These will be available
regardless of which tab is selected (global to the form).

When you play with it for a while, you'll get the hang of it. Then you can
fancy it up with colors, etc.
 
i have a really big form that i am creating is there a limit on how long
the form can be. im trying to add more input fields and it wont let me
scroll down any further with the scroll bar on the right does this mean i
cant go any further and it is limited to so much space?

Just FWIW, a form is limited to 22" by 22".

Tab Controls are a MUCH better alternative.

Proper table normalization (so you don't have hundreds of fields) is
even better yet!

John W. Vinson[MVP]
 
Back
Top