Repeat Section Problems


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

Advertisements

M

Marshall Barton

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?

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.
 
G

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.
 
M

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

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.


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.
 
M

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.
 
Ad

Advertisements

J

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.

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
 
G

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.

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
 
M

Marshall Barton

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

Advertisements

M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat Section property problem 1
Repeat Section 1
Repeat Section 1
Repeat Section property problem 0
Conditional Repeat Section 3
Repeat Detail Section 1
Repeat on Report section. 1
Repeat detail section of report 2

Top