Repeat Section Problems

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

Guest

I have 3 group headers on a report. Repeat Section is set to Yes for all 3
sections. When I preview the report it just hangs. I changed the repeat
section to No and the report now previews.

This just started happening about a month ago. The reports worked fine
before then. Can you give me some ideas on what is causing this now?
 
frustrated said:
I have 3 group headers on a report. Repeat Section is set to Yes for all 3
sections. When I preview the report it just hangs. I changed the repeat
section to No and the report now previews.

This just started happening about a month ago. The reports worked fine
before then. Can you give me some ideas on what is causing this now?
Click to expand...


The only time I've seen RepeatSection cause a hang is when
there was some code in the section's Format or Print event
that prevented the section from being displayed. E.g. made
invisible or canceled.
 
Thank you. I first suspected my code in the Print event, so I deleted them
and the report still wouldn't print preview. I found another post from a few
years back and someone thought it might be a memo field property set to can
grow that's causing the problem. I changed all my memo fields can grow
properties to No and the report previews, but my memo fields are truncated.
I guess I'll have to live without repeating group headers.
 
Good searching! I have never seen the memo field issue. If
a can grow memo by itself can cause this failure, it would
make the feature near useless so there's got to be something
more to it.

BTW, I seem to remember noticing that in A2003, when I made
a repeat section invisible or canel its format event, it
didn't hang. Instead, it changed the RepeatSection property
to No. Talk about bailing out on a bug :-(
 
I've seen similar behavior. If the memo field is too large to fit on one
page, then the bug seems to occur.


Marshall Barton said:
Good searching! I have never seen the memo field issue. If
a can grow memo by itself can cause this failure, it would
make the feature near useless so there's got to be something
more to it.

BTW, I seem to remember noticing that in A2003, when I made
a repeat section invisible or canel its format event, it
didn't hang. Instead, it changed the RepeatSection property
to No. Talk about bailing out on a bug :-(
--
Marsh
MVP [MS Access]

Thank you. I first suspected my code in the Print event, so I deleted
them
and the report still wouldn't print preview. I found another post from a
few
years back and someone thought it might be a memo field property set to
can
grow that's causing the problem. I changed all my memo fields can grow
properties to No and the report previews, but my memo fields are
truncated.
I guess I'll have to live without repeating group headers.
Click to expand...
Click to expand...
 
John, there has got to be more to it. I can not reproduce
it in either A2002 or A2003 using a simple report with a
memo field that splits across a page boundary. I tried with
all kinds of combinations of group and section KeepTogether
to see if that might be a factor, but all cases worked ok.
 
Well, it was a while ago and it was in Access 2000 (if I recall correctly).

I believe the settings were
-- Keep together for the section with the memo field (and other controls
bound to fields)
-- **IF** I recall correctly I also had a group in front of that with Keep
together with first detail.

I don't remember any of the other settings. Unfortunately, I also don't
remember the application and report where I encountered the problem.

Marshall Barton said:
John, there has got to be more to it. I can not reproduce
it in either A2002 or A2003 using a simple report with a
memo field that splits across a page boundary. I tried with
all kinds of combinations of group and section KeepTogether
to see if that might be a factor, but all cases worked ok.
--
Marsh
MVP [MS Access]


John said:
I've seen similar behavior. If the memo field is too large to fit on one
page, then the bug seems to occur.


"Marshall Barton" wrote
Click to expand...
Click to expand...
 
I'm using A2002. On your report try this: put the memo fields side-by-side
and size them about 1 inch wide. Your memo fields should have a lot of text
in them so they can grow.

I just tested this on my report, except I put the memo fields vertically, so
they would have room to grow and the report ran fine. But the report hangs
up when the fields are side-by-side.

Marshall Barton said:
John, there has got to be more to it. I can not reproduce
it in either A2002 or A2003 using a simple report with a
memo field that splits across a page boundary. I tried with
all kinds of combinations of group and section KeepTogether
to see if that might be a factor, but all cases worked ok.
--
Marsh
MVP [MS Access]


John said:
I've seen similar behavior. If the memo field is too large to fit on one
page, then the bug seems to occur.


"Marshall Barton" wrote
Click to expand...
Click to expand...
 
I can't get that arrangement to fail either.

At least you figured out part of the issue, but I still
think that it a combination of factors.
 
Back
Top