-----Original Message-----
(resending because my first reply doesn't seem to have made it)
Pardon me, Walter, but I'm not sure whether you're saying that your
question has been answer, or that it hasn't. The no- code method Jeff
described (courtesy Rick Brandt) requires you to do a little work at
design time on the form, but nothing at all at run time. There is no
method I know of that will let you do it without at least doing
something to each control at design time.
You can write a pair of functions, HighlightControl() and
UnhighlightControl(), and set them to be called from each control's
GotFocus and LostFocus events. That code wouldn't need to be told which
control is the one in question, because it can use the form's
ActiveControl property to tell it. However, you do need to do the work
at design time to get the functions called by the appropriate events.
And it won't work properly on continuous forms.
You can also use Conditional Formatting -- in Access 2000 or later -- to
set various formatting attributes of each control depending on whether
it has the focus or not. That will work on continuous forms, but you
have to set it at design time for each individual control.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
.
I appreciate the info. I'll set each control.