Re-Formatting a Data Entry Form

  • 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
 
John C. Harris said:
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...

Look through all controls and note which ones have "[Event Procedure]" in the
property sheet. Write this down as you'll need it later.

Add a TabControl at the bottom of the form.

Select all controls you want on the first Tab Page and "Cut" them to the Windows
Clipboard.

Select the first Tab Page and "Paste". All of your controls that you previously cut
to the clipboard should now be on the first tab page. To confirm this, make sure you
do not see the controls when you go to the second tab page and that all of the
controls stay with the TabControl when you move it around.

Repeat this procedure for all of the controls you want on the second Tab Page.

Position the controls where you want them on the tab pages and then position the
TabControl itself to where you want it. Then go through your list of controls that
had [Event Procedure] settings. These will all have to be reset because cutting and
pasting them will not retain this. The code that the event is calling will still be
there in the form's module. All you have to restore is the entry "[Event Procedure]"
in each property box.
 
Back
Top