how many controls on a form?

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

Guest

Hello,
I need to build a form to collect data from a questionnaire.
The questionnaire will have something like 400 questions, maybe more.
I’m thinking how to design the form and how to deal with the limitation of
255 controls on one form. I was wondering:
a) when you put a text box on a form, it comes with its label. Would this
count like having 2 controls on the form (the label + the textbox) or just
one?
b) An option group with lets say 3 choices, will count like having 8
controls on the form (one label for the whole group; one rectangular control;
one label and one check box for each option)?
c) using a tab control will override this limitation? I mean will each page
of this control count like one form accepting 255 controls? So that if you
have 2 pages you can arrange 510 controls? I would say NO, since the tab
control will stay in the form and will count like one of the control of the
form itself giving a remaining *space* for other 254 controls, wherever you
put them, on the form or on the page of the tab control.
d) even if the form is unbound will it have a maximum of 255 controls on it?
Otherwise I could manage to save data in the table using SQL or ADO through
code.
I would say there is no chance to have more then 255 controls on the form,
so the answers to my questions would most likely be: a) YES; b) YES; c) NO;
d) NO
But I’m wrong so many times!! Maybe this time I will be wrong in my favor.
Thanks,

Rocco
 
By the way, the limit is 255 fields in the query.
A form can have up to 754(?) controls on it during its lifetime.
And you are right a Label is a control, a line is control, an option group
is numerous controls.
Adding a tab is adding a control.

A subform is a control. Now a Subform can have up to 754 controls on it.

But Allen Browne's advice is correct. You really need to revisit the design
structure and Duane Hookom's At Your Survey example is a good one for
understanding the concept of designing surveys. As a matter of fact, it
often is all you need.
 
Thank you Allen,
I have found a way to rich the software you have mentioned. Very intersting,
but a bit behind the scope of my question.
I would just simply know if the limitations of 255 controls on a form is
kind of *strict* or can be somewhat overridden. I know that by using code you
can manage this issue pretty well, and I have already build an application
which manage more than 600 questions by simply changing the question one at
time on a form that has just five controls (textbox for the question; textbox
for the question's number; 3 command button for "yes", "no", "not applicable".
But I will not be payed for an effort of more than 3/4 hours. So I want to
stay very simple and use - if any - every wizard...prebuild funcion...and so
on. No code at all, if possible since they want the application in mdb format
and totally unprotected.
Maybe the best way to go - since my limitations - is splitting the
questionnaire in more than one form.
 
Thanks.
This fully answers to my questions.
I can use an unbound form and few lines of SQL statments to push data into
the tables.
I have seen the software you and Allen are mentioning. As I posted Is very
intersting and I will studied it but for some other occasion. i will not be
paid for such an effort and they just want to insert data collected from a
paper-form. I don't have to deal with the questions itself but with just
their numbers on the paper form. So I don't know what the question 1 will
ask. i only know there is a question 1,2,3...and all of them will be answered
with numbers going from 0 to 8.
maybe I wasn't clear about my needs, and in this case I apologize while I
thank you and Allen so much for taking care of my question and having
provided my with such a great example on how to build a survey.
I will run to look at that applicationa s soon as I end this post.
Thank,
Rocco
 
The form is limited to around 700 on controls (including labels etc as you
noted.)

However, there is no way that I would attempt to set up all those controls
and the programming logic associated with them. Designing the database
correctly would be simpler IMHO.
 
Back
Top