Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

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,
0
Startrac98
Asked:
Startrac98
1 Solution
 
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
 
Jim Dettman (Microsoft MVP/ EE MVE)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
 
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

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Tackle projects and never again get stuck behind a technical roadblock.
Join Now