form updating

[Staelens30]

ok i have finally figured out how to get hidden fields on a form to show and hide based on a checkbox selection my next question is how do you get the rest of the fields to move up to the blank space and move down when the hidden fields are shown.

 

[boblarson]

You would have to add or subtract from their TOP value in Twips (1440 = 1 inch).

So something like:

Me.YourTextBoxNameHere.Top = .75 * 1440

The TOP number is the distance from the top of the form's inside edge. So, if you find out what the current top is for the control and then you can modify it accordingly. So let's say your text box is now at 4.32" according to the TOP property in design view. And your top most checkbox is at 3.2" and you want the text box top to be right where the top of the checkbox is (or close). You would use:

Me.TextBoxNameHere.Top = 3.2 * 1440

Hope that makes sense.

 

[boblarson]

Here's a quick sample