Re: Maximum height of a form

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

That sounds as if the Form1 and Form2 are subforms on Form3. So they are
open as controls on the Form3.

Did you check to see what the name(s) of the subform CONTROLS are on form
3? The name of the subform control is not necessarily the same as the same
of the form you used as the source for the subform control.

When you create subform controls, the form used in the subform is NOT open
as a form.


"JoeA2006" <JoeA2006@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A8D6517B-1EF8-43B7-8232-09C9F6B2A111@xxxxxxxxxxxxxxxx
#Name? appears in the text box.

How would I guarantee the Form1 is open ?

I ended up putting a tab control on another form -"Form3" and putting
Form1
on one tab and Form 2 on another tab. Would this make any difference on
how I
would refer to the controls on either tab.
I each form is on a tab are they considered Open?


"John Spencer" wrote:

That looks correct to me IF Form1 is open and if Form1 has a subform
control
named Subform1 which has data.

What error are you getting?


"JoeA2006" <JoeA2006@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D8CDD763-15D0-472E-BEC5-6C8E225983D3@xxxxxxxxxxxxxxxx
Thanks. For the time being how would I reference a textbox on a subform
from
another form .

I used this as a control source for a text box on form2
=Nz(Forms![Form1]![subform1].Form!txtAmount,0)
but I keep getting an error

"John Spencer" wrote:

And to answer your specific question.
Yes, Access forms and report layouts have a maximum height and width
of
approximately 22 inches. By the way there is also a maximum number of
controls that can be placed on a form or report layout - if I recall
correctly that is 754 controls.

Look up Specification in the online help for more limits.

Rick B's suggestion of using a tabbed form is the way to go.
Especially
if
you combine the tabbed control with subforms.


"Rick B" <Anonymous> wrote in message
news:OFXy8wbpGHA.2464@xxxxxxxxxxxxxxxxxxxxxxx
Why not just make it a tabbed form? Place different type of data on
different tabs.

--
Rick B



"JoeA2006" <JoeA2006@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7826F655-0DB6-44BF-BAA0-EC3EA6B1198F@xxxxxxxxxxxxxxxx
I am building a large form that goes past 22" in height. When I
tried
to
change to property to increase the height Access displayed a
message
that
said the "number was too large". Do access forms have a max height?

I went ahead and built another form but I need to know how to
reference
text
fields on the first form for calculations.

What is the best way to handle displaying large forms?










.

Relevant Pages

  • RE: Change existing form to tabbed form
    ... Size it and move the tab control so that it is convenient to work with. ... Select all of the controls on the form that you want to put on a tab. ... "sharonm" wrote: ... change this to a tabbed form and keep all the existing fields on one tab and ...
    (microsoft.public.access.forms)
  • Re: Synchronization and references
    ... When you added the two forms as subforms on Form5000, ... those controls may not have the same names as the forms being used as the ... To create the tabbed form, ... control and dragged frm_Units to tab one and form1000 to tab two. ...
    (microsoft.public.access.forms)
  • Re: Spontaneous loss of subform bookmarks
    ... I tried running with the timer event off and no difference. ... The alignment in the subform controls is just about requerying controls ...
    (comp.databases.ms-access)
  • Screen Jumps while tabbing through
    ... Using Access2003 as I tab through the controls on a tabbed form when I get ... irritating. ...
    (microsoft.public.access.formscoding)
  • Re: Unbound list box in a read only form
    ... lock all the controls on the form who's module it is run from. ... That includes locking the subform controls which in effect locks the controls on the subform's form. ... It's easy enough to unlock a control on the main form. ...
    (microsoft.public.access.formscoding)