Report hangs (1 Viewer)

AlanS

Registered User.
Local time
Today, 01:40
Joined
Mar 23, 2001
Messages
292
I've got an Access 97 application with several reports, all of which have opened quickly and without error for some time. All of a sudden, one of them always immediately hangs with the message "Formatting page, press Ctrl+Break to stop..."

The report is based on a query which joins two tables. The query itself opens quickly and displays the correct records and fields. The only recent changes that seem relevant are that several of the included fields have been changed from Text to Memo, but none of them has a huge amount of text.

Any thoughts, suggestions or magic will be greatly appreciated.
 

AlanS

Registered User.
Local time
Today, 01:40
Joined
Mar 23, 2001
Messages
292
I created a whole new .mdb file, imported all the database objects into it, compiled and saved it, compacted and repaired it, and the problem is still there.

On closer inspection, it appears that hang occurs only with one group of records (out of about 75), yet there is nothing unusual or remarkable about those records.
 

Users who are viewing this thread

Top Bottom