Survey Form...

drblackard

Registered User.
Local time
Today, 08:10
Joined
Aug 15, 2006
Messages
22
I have a survey form that contains about 200 questions. It is a training matrix that we use at work. I am trying to automate everything since I have been put over training. I got a medical database from someone here and modified it a little. After entering about 60 questions my form said that it was too big .. it is 22" long and has a bunch of YES/No question of completion. Can someone tell me how to make the form longer ... it is set to Single Form since I only want to look at one person at a time. Help would be greatly appreciated. Thanks. :cool:
 
The 22" inch limit is just that, a limit! Forms that require the user to scroll up and down are very user unfriendly and really should be avoided. The best alternative is to use a tabbed form control. Users can view/fill in one page of questions at a time, click to move to the next page and so on. People taking surveys often leave questions blank, preferring to come back to them after they've completed the rest of the form. Tabbed pages with no scrolling makes this process much easier. Tabbed pages also provides an intuitive way of dividing data/questions into logical groups.

Here's a very brief tutorial on using tabbed pages:

First thing to remember is that the Tabbed Pages are all part of a single form; think of it as a really long form turned on its side. Because it is all one form, all referencing to any control on it is done in the same manner as if they were all on one single screen. Create a form in Design View. Goto the toolbox and click on the Tabbed Control icon; it actually looks like several manila file folders. Place it on your form and adjust the size to your liking. If you need more than the two tabbed pages it initially gives you, click on the tabbed control to select it. Goto Insert and click on Tabbed Control Page and another tabbed page will be added. Do this as many times as necessary.

This is the really important part: when you go to add a control to a tabbed page, you must first click to select one of the pages, then add the control. Otherwise, the control will be added to the form itself, and will show thru on all tabbed pages!

Once you have the form's Control Source (your table or a query) set up, you simple add controls as you normally would, heeding the above paragraph.
 

Users who are viewing this thread

Back
Top Bottom