Highlighting Field Headers on Subform

[JohnV]

I have a form with a subform. My form is based upon
office location and the subform is based upon employees at
that location. There can be multiple employees for each
location. Each employee record on the subform takes up 3
lines. What I would like to be able to do is highlight
the Field Header for the particular field that has focus
on the form.

Any help would be appreciated.

Regards,
JohnV

 

[David Brownstone]

You could try Event Procedures [in each field]

On Got Focus [or On Entry]
me!fieldname's label.FontWeight = x

where x is the sequence number of the Font Weight list in
Properties, the first [in the list being zero, then 1,
etc.]

and another On Lost Focus [or On Exit] to reverse the
effect.

Instead, you could change the background colour of the
field itself [not the label]

Me!FieldName.BackColor = [say] 16777215 [for white], etc.

Regards
Dave B.