Office Professional Plus Identifying the Record Se
 

Today’s guest blogger is Edwin Blancovitch. Edwin is president of Advanced Developers.net, creators of Easy Payroll,Office Standard 2010, a software package to manage your human resources, payroll, scheduling,Office 2007 Professional Plus Key, time and attendance needs. Regularly when we create databases for our customers we use continuous forms for data entry. The problem is, it’s often difficult for users to identify the record they’re working on a big continuous form with tons of records. I’ve found a way to overcome this in just a few just quick steps that I’d like to share with you guys. This is fully compatible with previous versions of Access, because I have been doing this my whole life. Actually, I just found it by mistake, while trying to create a conditional formatting event. We can do this with conditional formatting but this method is easier. First select the continuous form. Set the Back Color of all the controls in the detail section of the form to the color that you want to be displayed when the user clicks the control. In this example,Office Professional Plus, I’m using #ADC0D9. Set the Back Style property of all the controls in the detail section of the form to Transparent. Now, when you display the object in form view you will see the selected control highlighted with the color you have selected in the Back Color property of the control. YEAH, now all your users can easily identify the current selected record and even the selected control where the cursor is. That’s all,Office Pro 2010, no code,Microsoft Office 2010 Key, no difficult conditional format to configure. You can download a sample database that illustrates this method here. Send your Power Tips to Mike and Chris at accpower@microsoft.com. <div