increase size of form

[Guest]

I have made this question before, but I don't think I did not explained that
well. I have created a form with a lot of controls, and I have dragged down
the form foorter all the way down up to its limit. I wonder if there is a way
to keep dragging down the form footer so I can make appear all my controls in
only one form?

Miguel

 

[Rick B]

Why do you need that large of a form? Does not seem like that would be
practical for your users to use when inputting data. Why not break the
items down and use subforms, tab controls, etc.

Is your data structure normalized? What are your users using this form to
do, that requires so many controls?

More details about your form please.

 

[Guest]

Rick:
The form I'm creating is from a questionnaire, which includes a large number
of controls for my form. The users will be calling people and asking a large
number of questions. The reason that I want them all to appear in only one
form is because the users would not have the need to be jumping from one form
to another. I think it might be easier to include all in one form, but I'm
not sure now. In addition, my database is not normalized yet. How can I
create subforms and tab controls, and what use would they be to my form?
Miguel

 

[Rick B]

If you are asking several questions and recording answers, then I would
expect each question to be a separate record. Your form would then be a
continuous form that includes all the records. This would have a scroll bar
to allow them to scroll from one to the next.

There are already many database templates out there for this purpose. The
one I hear about the most was created by one of the MVPs and is called "at
your survey".

Sounds like you are adding a field for every question and answer. In my
opinion, that will be an absolute nightmare. What if a question changes?
What if you need to add one? What if you need to remove one? You don't
want to have to change the DESIGN to update the data. Your users should be
able to go to a form and modify/add/delete the questions without having to
know how to build a database. I would step back and totally rethink the
design.

This is my opinion, you may get some other responses.