Report not previewing

[branston]

Hi,

I have a report that was working fine, but now whenever I try to view it, it doesnt work. Basically, if I try to open it it thinks for a while and then just stops as if you'd never done anything. If I have it in design view (which I can get to fine) and then try to preview it it thinks for a while and then goes back to design view.

Any ideas whats going on?

I had a look at the record source query and that has around 700 records in, so it's not that the query isn't working, I have also tried to remove some of the boxes on the report and that isn't working either.
I've tried a compact and compress but that made no difference.

If anyone has any ideas on why this is happening (and how to fix it) please let me know!!!

Thank you.

 

[AlienRay]

Will the report open if you open the underlying query first? Sometimes reports will respond better if the underlying data has already been processed.

If it still doesn't work, my favorite diagnostic tool is simply to start removing fields until I find the culprit. If there are a lot of fields on the page, you can try deleting everything, and see if the report will run blank.

 

[boblarson]

Or, try importing everything into a new, blank database file and see if that helps. Sometimes corruption starts creeping in and doing an import like that will clear it up.

 

[branston]

Hi. thanks for your suggestions. I have played around with it, and I think I found the culprit - I should have mentioned that it had some code on teh form for conditional formatting. I think there was a slight corruption in the form which somhow meant there was too much conditional formatting or something... as if I deleted half the code it worked (sometimes)
Anwyay, I imported the table from a previous version and that worked (although when I tried to add more formatting the same thing happened, hence the reason i think it had reached a 'limit' or something) But I have found a way round it so all fixed.

Thank you!