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?

Microsoft Access

Last Comment

SteveL13

8/22/2022 - Mon

SteveL13

1/27/2018

ASKER

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

ASKER CERTIFIED SOLUTION

SteveL13

1/27/2018

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Gustav Brock