“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


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 *