Highlighting field in subform

  • Thread starter Thread starter Don Moore
  • Start date Start date
D

Don Moore

I want to hightlight the field the has the focus but I can't seem to get it
to work on my subform. I tried me.fieldname.backcolor=vbyellow but it does
seem to work with a datasheet view. Is there a another way. BTW I'm using
Access 2007
 
Don Moore said:
I want to hightlight the field the has the focus but I can't seem to get it
to work on my subform. I tried me.fieldname.backcolor=vbyellow but it does
seem to work with a datasheet view. Is there a another way. BTW I'm using
Access 2007
Click to expand...

Access allows only changes to the entire datasheet's backcolor. Sorry.
Access is not Excel...
 
You'd best use the conditional formatting for this. Select the fields which
you want to color when they have focus and apply the conditional formatting
option. Choose 'field has focus' option and choose the appropriate background
color for it. No need for coding here ;-)
 
Back
Top