“Replays” are fun if you’re playing a game. They are no fun when designing Access database forms and reports. We’ll show you an easy way to save time every time you create a new form or report.

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 that the wizard creates. You have to resize all the controls and align them and change the font, background color, back style. I get tired just thinking about it. Here’s a time-saving tip that can greatly speed up your form and report development time.

You can save a lot of time by creating and using your own custom form template and default control properties. To create 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 create a report template. Click OK and you’re ready for faster form development.

The next time you create a new form or report, it will have the form and control properties that you saved in the template. If you create a lot of forms and reports, this tip will save you a lot of time.

You can get more information here:

Techrepublic article

Allen Browne website

RELATED ARTICLES

True love never grows old

People commonly think of falling in love and, one way or another, suddenly falling out of love. Well, there is a certain feeling where we can feel an adrenaline rush every time we see each other, or stay with that person in the same room,…

Leave a Reply

Your email address will not be published. Required fields are marked *