Report locking up (memo fields)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an MS Access report with 3 groups, and then sorted by a field within
the details section. It works great, and the users are excited. The report
is generated by the users selecting values from some drop down lists, a query
being built by code, and the report opening up (populated by the query built
in code).

The only problem I have, is if the users select values from the drop down
lists that contain larger data sets, the report locks up (I have to
ctrl-alt-del to exit the database).

I have tested this out, and with the larger data sets, the query returns the
information in a split second (no delay at all). The report locking up I
have traced to one field (that is on its own side of the report (no fields
above or below it) that is allowed to "Grow". It is a "memo" field type, so
it gets very large. At 10 point Arial Font, if the data set is large, this
field trying to grow appears to lock up the report. I played with this, and
found the largest font I can use and not lock the report up, is Arial 6 pt.

Has anyone ran into this problem, and if so do you have any solutions? For
now I am going to create the report with this field being 6 pt font (until I
hear other wise).

Thank you,

TJ Bernard
 
What other settings do you have on your report and its controls?

If you have the Memo field set to CAN GROW and the Section control set to keep
together (or one of the group sections set with keep together), then Access runs
into a problem.

It has a memo field to put all on one page, but it won't fit on one page because
it is too big.
So, it tries the next page (doesn't fit here)
So, it tries the next page (...
 
This worked for me.

Thank you very much.

John Spencer (MVP) said:
What other settings do you have on your report and its controls?

If you have the Memo field set to CAN GROW and the Section control set to keep
together (or one of the group sections set with keep together), then Access runs
into a problem.

It has a memo field to put all on one page, but it won't fit on one page because
it is too big.
So, it tries the next page (doesn't fit here)
So, it tries the next page (...
Click to expand...
 
Back
Top