Access hangs formatting long subreport

[Mr Smin]

Hi,

I have a subreport which works correctly when it displays a few records, but when it returns enough to make the subreport more than one page long, Access' status bar shows "Formatting - press ctrl+break to stop" and hangs.

Please could someone tell me a way around this?

Thanks.

Smin.

 

[HiTechCoach]

Try setting the Keep Together property to No. I think you want to change this fior the section of the main report that hold the sub report control,

 

[Mr Smin]

Thanks HTC - solved my problem!

 

[HiTechCoach]

You're welcome!

Glad we could assist.