What is the limit on fields to pri in Access and can I change it?

[Guest]

I am trying to print an inventory d/b from access. I get an error " too many
fields to print, please decrease the amount of fields and try again" What is
the limit and can it be changed?

 

[Bill Mosca, MS Access MVP]

It would help if you told us how you are printing. Is it a report, a table
in datasheet view, a form, or what?

And what business need requires that you print out an "inventory database"?

 

[Guest]

Bill,

I am trying to print from a report with 4 different tables with a total of
26 fields.
The Gov't needs to see this (Census).

Roger

 

[Guest]

If you have done a lot of editing on the query or report you need to Compact
and Repair your database by clicking on menu TOOLS - Database Utilities -
Compact and Repair Database.

 

[Brendan Reynolds]

Does this error perhaps happen when trying to create a report using the
report wizard? There appears to be a limit on the number of fields the
wizard can handle, so if that's what is happening, try creating the report
without using the wizard.

 

[Bill Mosca, MS Access MVP]

26 fields should not be the problem. Follow Karl's suggestion. If that does
not work, create a new blank DB and import everything into it or create a
new report and copy the controls from the old one on to the new one.

One of the "bugs" in Access is that you are limited to the number of
controls you can put on a report or form (754) over it's life time. Once you
put a control on said object, it stays counted. You might have reached that
limit.

 

[Guest]

Thank You very much!

Does this error perhaps happen when trying to create a report using the
report wizard? There appears to be a limit on the number of fields the
wizard can handle, so if that's what is happening, try creating the report
without using the wizard.

 

[Guest]

Thank you very much!

26 fields should not be the problem. Follow Karl's suggestion. If that does
not work, create a new blank DB and import everything into it or create a
new report and copy the controls from the old one on to the new one.

One of the "bugs" in Access is that you are limited to the number of
controls you can put on a report or form (754) over it's life time. Once you
put a control on said object, it stays counted. You might have reached that
limit.