By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 992 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

Force Textboxes to new page in Reports --- Help

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Mark,

I don't know if this will work so it's only a thought ---

Group on the textbox and set the Keep together property to Yes.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Mark" <mc******@uoguelph.ca> wrote in message
news:14*************************@posting.google.co m...
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.