Highlighting field in subform

[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

 

[Stuart McCall]

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

Access allows only changes to the entire datasheet's backcolor. Sorry.
Access is not Excel...

 

[Maurice]

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 ;-)