# Fields in Report

[Guest]

I am getting this error (Access 97): You tried to perform an operation that
involves more than 255 fields. Reduce the number of fields, and then try the
operation again.
in a report. Now, I have read that there can be 754 fields or something
like that. Does anyone have any idea what could be going on here. There are
more than 255 fields, but less than 754.

 

[Brian]

I am getting this error (Access 97): You tried to perform an operation that
involves more than 255 fields. Reduce the number of fields, and then try the
operation again.
in a report. Now, I have read that there can be 754 fields or something
like that. Does anyone have any idea what could be going on here. There are
more than 255 fields, but less than 754.

I've never heard of any kind of field limitation involving 754. 255 is much
more likely, since that is the maximum number of fields in a table. I'd go
with what the message is telling you: sounds plausible to me.

 

[Joseph Meehan]

I am getting this error (Access 97): You tried to perform an
operation that involves more than 255 fields. Reduce the number of
fields, and then try the operation again.
in a report. Now, I have read that there can be 754 fields or
something like that. Does anyone have any idea what could be going
on here. There are more than 255 fields, but less than 754.

I wonder why you would need all those fields, but here is the answer for
Access XP version, your numbers may vary if you have a different version.


Number of characters in a label 2,048
Number of characters in a text box 65,535
Form or report width 22 in. (55.87 cm)
Section height 22 in. (55.87 cm)
Height of all sections plus section headers (in Design view) 200 in.
(508 cm)
Number of levels of nested forms or reports 7
Number of fields or expressions you can sort or group on in a report
10
Number of headers and footers in a report 1 report header/footer; 1
page header/footer; 10 group headers/footers
Number of printed pages in a report 65,536
Number of controls and sections you can add over the lifetime of the
form or report 754

 

[George Nicholson]

If you haven't compacted recently, do so, it may change the "count" Access
is having a problem with. Then see if you get the same message.