Microsoft Office 2010 Home And Business Power Tip

Today’s guest blogger is Nadia Szucs, president of N-Soft, a provider of IT consulting services to businesses of various sizes in the Greater Toronto Area (Canada). N-Soft specializes in custom Microsoft Office product solutions centered around Microsoft Access implementations. I would like to share a method that would speed up your development efforts. Take a Text Box control, for example. While designing a form or report and placing a Text Box, the Label control is attached to the Text Box. Sometimes, this is not what you want, so you delete the label. If you have many Text Boxes that do not need labels, it can amount to a lot of clicking and deleting. To avoid this, you need to change default behavior of the control. You can do that by opening the Form or Report Designer, selecting the control on the Ribbon Control tab and then opening a Property Sheet on the Tools tab. Change any property and close Property Sheet. In our example, change Auto Label property from Yes to No. Close the Property Sheet and continue designing. From now on, if you place a Text Box on the form or report, no label will be attached. You can change it back if you want later. Do not forget to record default settings before doing any changes in case you want to go back to the default behavior. Use this technique to set up a common look and feel for your application. For example, you can set font or background properties for Labels and Text Boxes. Adjust LabelX and LabelY properties of the Textbox control to set up the position of the attached label. Be aware that control properties in Form Designer and Report Designer do not overlap. If you change the Auto Label property for a Text Box in Form Designer,Microsoft Office 2010 Home And Business, it would affect only Text Boxes that you put on the forms. If you need to have the same feature for reports, you have to open a Report Designed and change the Auto Label property for Text Box control. Remember, while designing form or report, using Property Sheet for controls on the Ribbon, you can alter default properties of the controls. As a result, you do not have to adjust a control's properties every time after you put them on the form or report. Hope some of you find this tip useful. Nadia Learn more about Access at and
Send your Power Tips to Mike & Chris at accpower@microsoft.com. <div