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