Access Wizards do a great job of helping you create a Form with the text boxes and combo boxes you need.  But, it does a lousy job of formatting the forms the Wizard creates.  You have to resize all of the controls and align them and change the font, background color, back style–I get tired just thinking about it.  Here is a time saving tip that can vastly speed up your Form development time.

You can save a lot of time by creating and using your own Custom Form Template and Default Control Properties. To make a Form Template, create a Form with the format and control properties you want and save it as "Template". On the Menu Bar click Tools | Options and then select the Forms/Reports tab.  In the Form Template box type "Template".   Note that you can also make a Report Template as well.  Click OK and you are ready for faster Form developing. 

The next time you create a new form it will have the form and control properties you saved in the Template Form. If you create a lot of Forms this tip will save you a great deal of time.

You can get more info here:

http://articles.techrepublic.com.com/5100-10877_11-6181942.html

http://allenbrowne.com/ser-43.html

Search VBA Help For: DefaultControl Property

Happy Computing,

Patrick Wood