?
Solved

Changing Background on a form for 1 record only

Posted on 2013-01-29
4
Medium Priority
?
267 Views
Last Modified: 2013-01-29
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
Comment
Question by:Startrac98
4 Comments
 
LVL 50

Expert Comment

by:Dale Fye
ID: 38831161
Use conditional formatting, Change the Condition from "Field Value Is" to "Field Has Focus"
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38831163
Use conditional formatting on the field.
0
 
LVL 59

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 2000 total points
ID: 38831170
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
 

Author Closing Comment

by:Startrac98
ID: 38831469
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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

568 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question