Re-Formatting a Data Entry Form (Repost...lost answer from Rock somehow)

  • Thread starter Thread starter John C. Harris, MPA
  • Start date Start date
J

John C. Harris, MPA

I am pulling a blank on this one and was hoping someone here could help. I
use to work on Access years ago but it has been awhile and cannot remember
how to do this:

I have a data entry form created by another vendor for the agency I am just
starting with. The front form is too long for the screen and you have to
scroll down to see all of the entries. There are two distinct sections on
the form that can be split into TABS at the top, which would make it much
more user friendly (Demographics and Tell Us About Yourself). How can I take
the second set of questions and make it a TAB selection on the top of the
form instead of having to scroll, with messing with the basic table
hierarchy resident in the database?

TIA,

John C. Harris
 
I am pulling a blank on this one and was hoping someone here could help. I
use to work on Access years ago but it has been awhile and cannot remember
how to do this:

I have a data entry form created by another vendor for the agency I am just
starting with. The front form is too long for the screen and you have to
scroll down to see all of the entries. There are two distinct sections on
the form that can be split into TABS at the top, which would make it much
more user friendly (Demographics and Tell Us About Yourself). How can I take
the second set of questions and make it a TAB selection on the top of the
form instead of having to scroll, with messing with the basic table
hierarchy resident in the database?
Click to expand...

Pretty easy actually!

I'd suggest opening the form in design view, expanding it even bigger
(to get room for the tab control), and selecting all the controls;
drag them down below the area visible onscreen.

Now use the toolbox to create a Tab Control with two tabs (no controls
on them yet). Label the tabs appropriately.

Then scroll down and select (shift-click) all the controls that deal
with Demographics. Type Ctrl-X to cut them to the clipboard. Select
the tab page on which these controls are to go by clicking the *tab
itself* - you cannot drag the controls onto the tab page; the entire
page should highlight. Type Ctrl-V to paste the controls onto the
page. Repeat for the Tell Us... controls.

You can then rearrange the controls on each tab page to suit, and
shrink the boundaries of the form to fit the tab control.
 
Thanks John. That was exactly the way to do it. What was throwing me was the
cut-paste vs the dragging. Once I read that it worked fine. Now to rejoin
these event procedures!

JC
 
Back
Top