Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Repeat Group Header during printing

Status
Not open for further replies.

DENewkirk

Programmer
Jan 19, 2006
14
US
Hello!

I have a simple Access report with a group header that repeats across pages in Print Preview, but when I actually print the form, Access resets the RepeatSection property to FALSE, and it cannot be set by a simple assignment statement in VBA (i.e., it generates an error message), though the documentation says it can. From this point, the property remains FALSE back in Print Preview.

I have searched with Google and found only one mention of this, from someone experiencing exactly the same problem--but no one had replied with a solution. It appears that having an event handler in the section turns the repeat off--though only when the report is first sent to the printer! We need the event handlers to format text in the group headers whenever a group is split.

I hope someone has found a solution to this problem.

Thanks,
Don
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top