Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    42

    Question Unanswered: Change the height of a form through vba

    Hi,

    I have a form that contains several subform.
    Is it possible to change the height of those subforms in code?

    I want to do that because I wnat to make the forms as compact as possible depending on the number of records they have...

    Any sugestions?

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Re: Change the height of a form through vba

    Originally posted by MrData
    Hi,

    I have a form that contains several subform.
    Is it possible to change the height of those subforms in code?

    I want to do that because I wnat to make the forms as compact as possible depending on the number of records they have...

    Any sugestions?
    Try the InsideWidth and InsideHeight properties of the subform to change the size of the internal stuff.
    Gregg


    DAO, ADO, SQL, Automation and anything else I can pick up.

  3. #3
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    42
    yes, I saw that to in the help... I seems to me that it's not possible to change the 'outer' size of the form,

    thx anyway!

  4. #4
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445
    Originally posted by MrData
    yes, I saw that to in the help... I seems to me that it's not possible to change the 'outer' size of the form,

    thx anyway!
    I guess I don't understand what you mean then. To resize the subform control on the main form, you just refer to it as Me.Subform.Width
    That will resize what I perceive as the "outer" form.
    Gregg


    DAO, ADO, SQL, Automation and anything else I can pick up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •