Auto Reformat of a form

B

Big Wes

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.
 
J

June7 via AccessMonster.com

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Link a text box based on drop down box with four options MS Word 365 0
Creating a Search using a combo box and then creating a report. 4
Create form with checkbox les that expand and collapse sections of the form? 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Dynamic Naming of Form Button 3
Populate a table based on check box status 2
Text duplication question 0

Top