Report locking up

[TJBernard]

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

 

[TJBernard]

I get so much great help on this board, I wanted to come back and share what I have learned.

I looked into this problem and found the reason the report was locking up was the "Keep Together" property. I had this set to yes on all my group levels. Once I set it to "no" on all group levels the report worked.

I guess large memo fields that "can grow" in a report where the groups are set to "keep together" lock up MS Access reports when they have large datasets.

Just something to keep in mind, thanks again for your time.

TJ Bernard