Form Layout

[Stemdriller]

Hi everyone,

Currently working on a DB, and would like some advice and guidance if poss.

I am using Tabs and on 1 particular tab there are 4 Sub Forms. All these subforms are hidden.

On a previous form there is a check box setup that if the user wants to see these 4 subforms he has too tick the check box, which then makes the corresponding forms visible. This works ok.

But on the Main form if the user has ticked Form 1 and Form 4, then Form 1 Shows nicely at the top but there is a gap until Form 4.

Is it possible to get Form 4 to become visible directly after Form 1. Or even if the user has selected Form 4, Form 4 will then appear directly at the top of the form???

Thanks
Gareth

 

[boblarson]

Yes, you can move them by setting the Top property of the subform control (control on the parent form which houses the subform). You would have to figure out the space (I'll use inches because that's what I use) that the forms take up. So, let's say that there is 5 inches between the bottom of the first subform and the top of the fourth. You can set the fourth subform to

Me.SubformControlNameHere.Top = Me.SubfornControlName.Top - (4.5 * 1440)

and that would move it up (the measurements need to be set to TWIPS so 1440 TWIPS to an inch and I just put in 4.5 * 1440 so it calculates it for me as I used 4.5 inches. I think it is 568 TWIPS to a cm.

 

[Stemdriller]

Yes, you can move them by setting the Top property of the subform control (control on the parent form which houses the subform). You would have to figure out the space (I'll use inches because that's what I use) that the forms take up. So, let's say that there is 5 inches between the bottom of the first subform and the top of the fourth. You can set the fourth subform to

Me.SubformControlNameHere.Top = Me.SubfornControlName.Top - (4.5 * 1440)

and that would move it up (the measurements need to be set to TWIPS so 1440 TWIPS to an inch and I just put in 4.5 * 1440 so it calculates it for me as I used 4.5 inches. I think it is 568 TWIPS to a cm.

Thanks Bob, I'll give it a try tomorrow.

 

[Stemdriller]

Bob

You are an absolute genius, complete and utter genius

Thanks again

Gareth