• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 67
  • Last Modified:

Resize rows on 2 datasheet forms to match vertical sizing

I have a main form that has two sub-forms on it.  Both of the sub-forms are datasheet forms. If I manually size the rows on one of the forms vertically I want the other one to size itself to whatever row vertical size I made the first one.

Is there a way to do this?
  • 3
1 Solution
SteveL13Author Commented:
There is actually a main form and a sub form and the two datasheet forms are on the subform.

As an experiment I put a textbox names txtDatasheetRowHeight on the sub form and did this afterupdate event.  But it doesn't work.  I get "Object doesn't support this property or method"

Forms!frmProjectBuilder.Form!frmFoundationBuilder.Form![subfrmFoundationBuilderCopy1].RowHeight = Me.txtDatasheetRowHeight
Forms!frmProjectBuilder.Form!frmFoundationBuilder.Form![subfrmFoundationBuilderCopy2].RowHeight = Me.txtDatasheetRowHeight
SteveL13Author Commented:
I just got it with:

Forms!frmProjectBuilder.Form!frmFoundationBuilder.Form!subfrmFoundationBuilderCopy1.Form.RowHeight = Me.txtDatasheetRowHeight
Forms!frmProjectBuilder.Form!frmFoundationBuilder.Form!subfrmFoundationBuilderCopy2.Form.RowHeight = Me.txtDatasheetRowHeight

Now if only I could make the vertical height change dynamically when I drag one of them, they both change.
Gustav BrockCIOCommented:
I doubt you can, as no event for this is exposed.
SteveL13Author Commented:
My solution worked.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now