Error 2100 in Report

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Sylvain

    #1

    Error 2100 in Report

    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
    control.top = 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.

  • Allen Browne

    #2
    Re: Error 2100 in Report

    Answered in another group

    Comment

    Working...