Office 2010 Identifying the Record Selected on a C

Today’s guest blogger is Edwin Blancovitch. Edwin is president of Advanced Developers.net, creators of Easy Payroll, a software package to manage your human resources, payroll, scheduling, 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,Office 2010, 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, 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, no code, 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