Solved

Changing Background on a form for 1 record only

Posted on 2013-01-29
4
259 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 47

Expert Comment

by:Dale Fye (Access MVP)
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 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Documents and settings folder 30 78
Dynamically Reorder List Box 4 38
Opening forms with an input box 5 22
Sum with where criteria on a report 5 15
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

809 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