"Highlighting" current record in form (1 Viewer)

[ddmcn]

Hi, all...this is my first post here.

I'm trying to figure out how I can highlight the current record on a form in datasheet view. In otherwords, change the backcolor on the fields in the CurrentRecord.

I have tried a coulple of things but Access changes the back color of all the records...

Any suggestion?

ddmcn

 

[Georgina]

I have had the same problem and found this in the forum:

http://www.mvps.org/access/forms/frm0024.htm

It has helped me, hope it helps you too!

 

[Autoeng]

I don't have Access at home but it is really simple to do (have it on my own database) and doesn't require any coding. Will post again Monday.

Autoeng

 

[Autoeng]

ddmcn:

Easy way to do this. Open the form in Design view. Select all of your input boxes (I think you can do them all at once, if not do one at a time), select Format - Conditional Formatting, Add a condition that if field has focus highlight to the color you desire.

Hope this is what you are looking for.

Autoeng

 

[ddmcn]

Thanks, Auto

Unfortunately, that method changes the color on all of the records. I will take a look at the download mdb when I get home this afternoon and see what code might be there to help.