G
Guest
Hi: Is there a max. # of fields that can be used on a form and report? Is
there another option to use to bypass?
there another option to use to bypass?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Yes, go to help and type "specifications" to see the limits.
The limits are over the life of the form so if you add a control, then
delete it, it still counts.
I think that compacting will reset this limt, but you may have to build a
new report and copy the objects over to reset the limit. You can search
past posts for more details.
The limit is very large and should rarely cause a problem in a normalized
database.
Why do you ask?
Rick B
The limits are over the life of the form so if you add a control, then
delete it, it still counts.
I think that compacting will reset this limt, but you may have to build a
new report and copy the objects over to reset the limit. You can search
past posts for more details.
The limit is very large and should rarely cause a problem in a normalized
database.
Why do you ask?
Rick B
M
Mark Phillipson
Acording to Access Help:
Number of controls and sections you can add over the lifetime of the form or
report is 754
I don't beleive this includes the contols a a sub form or sub report.
--
HTH
Mark Phillipson
Free Add-Ins at; http://mphillipson.users.btopenworld.com/
Number of controls and sections you can add over the lifetime of the form or
report is 754
I don't beleive this includes the contols a a sub form or sub report.
--
HTH
Mark Phillipson
Free Add-Ins at; http://mphillipson.users.btopenworld.com/
G
Guest
Hi Rick: I'm creating new Forms of the wizard and select the
AutoForm:Tabular. The Form is created off of an existing table. A AutoForm
Wizard box appears which reads "The wizard is unable to create your form or
report because you chose too many fields, please try again with fewer fields."
AutoForm:Tabular. The Form is created off of an existing table. A AutoForm
Wizard box appears which reads "The wizard is unable to create your form or
report because you chose too many fields, please try again with fewer fields."
R
Rick B
Not sure. I don't use the wizard.
CP said:Hi Rick: I'm creating new Forms of the wizard and select the
AutoForm:Tabular. The Form is created off of an existing table. A AutoForm
Wizard box appears which reads "The wizard is unable to create your form or
report because you chose too many fields, please try again with fewer fields."
K
Ken Snell [MVP]
How many fields do you have in the table?
G
Guest
K
Ken Snell [MVP]
Similar to Rick, I don't use the wizards...but I will guess that the wizard
has a limit on how many fields it can handle. Choose fewer fields, and then
you can always add more fields to the form later.
has a limit on how many fields it can handle. Choose fewer fields, and then
you can always add more fields to the form later.
B
Brendan Reynolds
I believe that the limitation you are running into here is not actually the
number of controls, but the width of the form. Because you're trying to
create a tabular form, the wizard is trying to make the form wide enough to
accommodate the 36 controls in a single row across the width of the form,
and is running up against the maximum form width (55.87 cm, or 22 inches).
number of controls, but the width of the form. Because you're trying to
create a tabular form, the wizard is trying to make the form wide enough to
accommodate the 36 controls in a single row across the width of the form,
and is running up against the maximum form width (55.87 cm, or 22 inches).
G
Guest
That seems right. I can't expand over the 22 in. If I create the form
manually I should be able to make it longer, correct? it will take for ever.
Thanks.
manually I should be able to make it longer, correct? it will take for ever.
Thanks.
K
Ken Snell [MVP]
good info, Brendan.
B
Brendan Reynolds
I'm not sure what you mean by 'make it longer'. You can't make the form any
wider than 55.87 cm / 22 in. If you create the form manually, you may be
able to make some of the controls narrower, or you may need to use a
columnar form rather than a tabular one.
A form that is wider than the screen really isn't very user-friendly,
anyway - too much horizontal scrolling is a PITA for the user.
wider than 55.87 cm / 22 in. If you create the form manually, you may be
able to make some of the controls narrower, or you may need to use a
columnar form rather than a tabular one.
A form that is wider than the screen really isn't very user-friendly,
anyway - too much horizontal scrolling is a PITA for the user.
B
Brendan Reynolds
I just played around a bit with the widest table I could find, and noticed
that I got the error with the tabular wizard but not with the other wizards.
--
Brendan Reynolds (MVP)
that I got the error with the tabular wizard but not with the other wizards.
--
Brendan Reynolds (MVP)
Ken Snell said:good info, Brendan.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.