too many fields defined

[sgagne]

I have a database in which I created a report from a query. The query
and report ran fine. I realized I forgot 8 fields on the report and
so I added them - just the controls, I didn't need the labels.

Now my query is still fine, but when I try to run the report I get the
Too many fields defined error. I have tried compacting and it still
doesn't work. I created a copy of the report and removed the 8 fields
and it ran again.

Is there any way to get this report to run with the 8 added fields?

 

[John Spencer]

Did you add the fields to the query first?
And then add the controls to the report that are bound to the fields in the
query?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[sgagne]

Did you add the fields to the query first?
And then add the controls to the report that are bound to the fields in the
query?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

The fields were already on the query, I just forgot to include them on
the report initially.

 

[John Spencer]

Interesting.

You are allowed up to 255 fields in a query and on a report. Are you
exceeding that limit?

What happens if you add just one field?
What happens if you delete a control and then add in a different one?

I guess it is possible that the report has become corrupted. In that case,
you might need to rebuild it from scratch after deleting the bad report and
compacting the database.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[sgagne]

Interesting.

You are allowed up to 255 fields in a query and on a report. Are you
exceeding that limit?

What happens if you add just one field?
What happens if you delete a control and then add in a different one?

I guess it is possible that the report has become corrupted. In that case,
you might need to rebuild it from scratch after deleting the bad report and
compacting the database.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.







- Show quoted text -

I have copied the report and deleted the 8 fields and then it runs.
There is not more than 255 fields.
I guess I can try rebuilding it - was hoping to avoid that

 

[Chuck]

I have copied the report and deleted the 8 fields and then it runs.
There is not more than 255 fields.
I guess I can try rebuilding it - was hoping to avoid that

Delete the 8 non-functioning fields from the report.
Drag the fields, one at a time, from the record sources Field List into the
report. Check the report after each field has been added. If the report fails
after one field check to determine what is 'bad' about that field. Could be in
query or table.

Chuck
--

 

[sgagne]

Delete the 8 non-functioningfieldsfrom thereport.
Drag thefields, one at a time, from the record sources Field List into thereport. Check thereportafter each field has been added. If thereportfails
after one field check to determine what is 'bad' about that field. Could be in
query or table.

Chuck
--

Tried removing the fields and adding one at a time. It let me add 3
then failed. I tried adding different fields, any one of them causes
it to fail - too many fields defined. I will check the fields in the
table and query. However, the query runs fine.

 

[Chuck]

Tried removing the fields and adding one at a time. It let me add 3
then failed. I tried adding different fields, any one of them causes
it to fail - too many fields defined. I will check the fields in the
table and query. However, the query runs fine.

Wild stab in the dark. I wonder if all the labels are also counted as
'fields'?

Chuck
--

 

[sgagne]

Wild stab in the dark. I wonder if all the labels are also counted as
'fields'?

Chuck
--

I rebuilt the report and I get the same error. I think I know the
issue. When developing the query I ran into the same issue, so I used
expressions to combine several fields from the table into one field on
the query (ExprS111: [qrySBRC_1-2MP1]!S111 & " " & [qrySBRC_1-2MP2]!
S111 & " " & [qrySBRC_1-2MP3]!S111 & " " & [qrySBRC_1-2MP4]!
S111). I used spacing to space the fields as needed in the report.
Well I guess that a report can only use 255 fields from the original
table - it doesn't matter that the query is only using about 115.

I tried using a subreport, but I couldn't get it to pull in
correctly. This is a report card for a school. When I tried to do a
subreport to pull in extra fields into the report card, it would not
align the students correctly.