Repeat Section Problems

[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?

 

[Marshall Barton]

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?

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.

 

[Guest]

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.

 

[Marshall Barton]

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 :-(

 

[John Spencer]

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

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.

 

[Marshall Barton]

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.

 

[John Spencer]

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.

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]

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

 

[Guest]

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.

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]

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

 

[Marshall Barton]

I can relate, John. At my age, EVERYTHING is more than a
while ago ;-)

 

[Marshall Barton]

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.