Changing Background on a form for 1 record only

I have a form that is continuous.  I need to change the color of background of a field for the record that has focus.  This will allow the user to know what record has the focus.  I know I can use Record Selectors = Yes.  Thanks,
Startrac98Asked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
Couple ways to do this.  One is to use conditional formatting on a bound control:

http://office-watch.com/t/default.aspx?a=981&template=print-article.htm

Another method along the same lines (but older) is this:

http://access.mvps.org/access/forms/frm0047.htm

And finialy, a method that does not rely on conditional formatting at all (sample attached).

Jim.
ContinuousFormColors.zip
0
 
Dale FyeCommented:
Use conditional formatting, Change the Condition from "Field Value Is" to "Field Has Focus"
0
 
IrogSintaCommented:
Use conditional formatting on the field.
0
 
Startrac98Author Commented:
Thank you very much for the answer to my question & samples.  I got a few more idea and your information was very helpful.
0
All Courses

From novice to tech pro — start learning today.