Added field causes extreme delay in spooling

[levieux]

Running Access 2000 I have a main report (with a
subreport) that takes about 20 seconds to format the page
and begin printing. The recordsource for both report and
subreport are queries that join three ODBC-linked SQL
tables. I added one date/time field to the subreport
query with a corresponding new text box to the
subreport. The query and subreport still run fine, but
when I try to run the main report with the subreport the
report never finishes formatting or spooling. I do not
get an error message. If I take the new field off the
subreport (even though I leave it in the source query),
the whole thing runs fine again.

 

[Duane Hookom]

Did you change any "can grow" properties of controls in the sub report?

 

[levieux]

No. They're all set to "NO". (I just copied a text box
that's already in the report and set the data source to
the new field.)

 

[Duane Hookom]

I have no idea why this would cause an issue if you didn't adjust the size
of the section or set something to can grow. I would also try to compact
after adding the control to see if that makes a difference.

 

[levieux]

Compacting didn't work. I am accessing this database via
Terminal Services and I asked a collegue in another
state, where the server resides, to try it. It ran fine
for him. He's going to try it via Terminal Services and
see if he has problems with it.

Thanks for your input.