Auto Reformat of a form

Hello. Thanks for the help. I have a form "Form1" with a number of
text boxes lined across the page and a check box. I wanted to know if
there is a way to shift several text boxes on my form and insert a new
text box if the check box is checked, but not show it if the checkbox
is unchecked.

Thank you.

Yes. Use AfterUpdate event of the checkbox. Include code that will change the
property settings of other controls (visible, enable, top, left, etc.) Note
that top and left have to be in twips, ex:
Me.tbxLabelNo8.Top = 4079.952 'twips, 1 inch = 1440 twips


Big Wes wrote:
Hello. Thanks for the help. I have a form "Form1" with a number of
text boxes lined across the page and a check box. I wanted to know if
there is a way to shift several text boxes on my form and insert a new
text box if the check box is checked, but not show it if the checkbox
is unchecked.

Thank you.

--
Message posted via http://www.accessmonster.com