Hello,
I have a report in MS Access 2002 that has a list of textboxes in a
row down the page. All these textboxes get variable length data from
the Control Source Table of the report or from a function call that
returns a string.
The textboxes all have their cangrow property set and grow correctly
to fit the information. The problem lies if a textbox overlaps two
pages. Part of the textbox will be on one page and the other page will
contain the rest. Is there any way to force the textbox to begin on
the new page if it will overlap a page???
I have been playing around with this for a while and i have set
invisible pagebreaks above each textbox and i check each textbox at
time to see if it will overlap (I wrote a method that will take the
page height minus the header/footer heights and pagemargin heights
then MOD with the top and bottom values of the textbox, if the bottom
modded is smaller, then obviously, the textbox got divided over two
pages.
The problem now is that i have no idea where to call this method. I
have to call it after all the textboxes have grown to their correct
sizes, but before Access calculates the pages for me. Basically,
onFormat is too soon, and Page() and Print() are too late.
Does anybody know where i should call this method, or know a better
way of doing this. The report only shows one record so i cannot use
the Grouping.
Thanks in advance.
Mark
mc******@uoguelph.ca