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

Error 2100 in Report

P: n/a
Access 2000
I am dynamicaly placing controls on a report and hiding some controls
based on caculated
conditions. The code is being called from Detail_Format.
I have 17 information boxes where 6 can fit on one page in the
following format
1 2
3 4
5 6
7 8

The situation is that the number of controls can vary anywhere from 4
to 10 per report, and the controls that are not pertinent are hidden.

Here is some background pseudocode to explain
if condition1 then = y
control.left = x

if condition 2 then
control.visible = false

The problems I am having are these.
1) If the hidden controls top and left are off my physical page, then
I get extra blank pages with only header and footer details.
2) If I place all the controls in design time so that physically, they
fit on one page, and move them at run time, once I get to control 7,
which is on or close to a page break, I get run time error 2100.
"The control or subform is too large for this location."

Also, it seems that if I have all my controls are on one page, my
hidden control's seem to unhide themselves and that detail_format gets
called twice.

How do I force a new page so that control's 7 and up to print on the
second page of the report.

I can be more specific if this is ambiguous.

Thanks in Advance for any help.

Jun 12 '07 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Answered in another group
Jun 12 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.