miscellany at mvps.org
Tue Aug 14 14:59:20 CDT 2007
Thomas, An alternative approach is to make a textbox, perhaps bound to your ID field, and size it to the full height and width of the Detail section of the form. Then, all the other data controls, you set the Back Style property to Transparent, and then they are laying over the top of the ID. Then you just apply the Conditional Formatting to the ID control, to change its ForeColor and BackColor, and it will give the impression of the whole row being highlighted. Regards Steve ewaldt at gdls.com wrote: > I got it! Thanks, everyone, for your help. In the unlikely event that > someone is as DUH as I am, I'll explain it below. > > Many were suggesting conditional formatting, but I could not see how to > make it apply to an entire row. It's actually very simple. With the form > in design view, select all of the appropriate fields and choose Format / > Conditional Formatting from the menubar. On the left, choose "Expression > is". On the right, type in the controlling expression, such as [ID] = 5. > Since you've selected all fields, they will all be governed by this one > expression. > > Sorry for being so dense, people. I hadn't used this functionality in > Access before, so I was trying to figure it out in VBA. Let's hear it for > trying to reinvent the wheel.
More information about the AccessD mailing list