Re: sub form size

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

From: mark r (anonymous_at_discussions.microsoft.com)
Date: 08/25/04


Date: Tue, 24 Aug 2004 20:30:35 -0700

OK good point, I guess I need to describe better.

I have a form, it has continuous forms. each record
displayed is only a half inch deep. and several records
fit on a screen.

on this first form is a command button which opens another
form (I did not actually create a subform and set the
container control sizes.

If the first form is small size, the command button opens
the second form also small. If the first form is maximized
and then you hit the command button ,the second form also
maximizes upon opening.

setting auto size to no doesn't help
putting me,minimize on the on open event property doesn't
help.

>-----Original Message-----
>Hi Mark
>
>I don't understand. This is the default behaviour. The
subform is limited
>to the size of its container control, and this does not
change when the size
>of the parent form changes, unless you have written
clever code in the
>Resize event to do it for you.
>--
>Good Luck!
>
>Graham Mandeno [Access MVP]
>Auckland, New Zealand
>
>"Mark r" <anonymous@discussions.microsoft.com> wrote in
message
>news:573401c48a35$f2ee9bc0$a301280a@phx.gbl...
>> how can I ensure that a subform will stay small sized
even
>> if the mainform/parent form is maximized?
>
>
>.
>



Relevant Pages

  • Re: The command button on my forms doesnt work, any clues why?
    ... "Subform" is a special term in Access, referring to a form that is within another form. ... When you open the main form, the subform opens in it. ... Pase the code the wizard created for you for the Click event procedure of your command button. ... my primary form to a detail form. ...
    (microsoft.public.access.forms)
  • Re: Creating subforms
    ... opens frmCourses, ... if so, then just use the Controls wizard to create a command button, and set ... it up to open frmCourses (the wizard will walk you through this). ... >> add a subform one of two ways: 1) add a subform control from the ...
    (microsoft.public.access.forms)
  • Re: DCount count records based on field value?
    ... That command button has the following ... Dim stDocName As String ... This code opens the second form and displays only the records from the ... the subform via the subform toolbox button/wizard, ...
    (microsoft.public.access.modulesdaovba)
  • RE: DCount count records based on field value?
    ... That command button has the following code ... Dim stDocName As String ... This code opens the second form and displays only the records from the table ... the subform via the subform toolbox button/wizard, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Command button to open a sub form
    ... I have tried the command button route because there physically isn't room ... first form then it is no longer a subform. ... record there and any new records you add will not automatically inherit the ... TabControl on your first form. ...
    (microsoft.public.access.formscoding)