[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Change colors for flagged people

Posted on 2012-08-30
Medium Priority
Last Modified: 2012-09-05
I have an Access 2007 DB with tables and forms. My project is I need to create a flag and then when something is flagged have it change colors, like red.

I know this is very vague, just dont know where to start.

Question by:CMILLER
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 1000 total points
ID: 38352954
LVL 61

Assisted Solution

mbizup earned 1000 total points
ID: 38353647
<< just dont know where to start. >>

The links cap1 has posted are a great resource, but if you need a little more fundamental info specific to your situation ('flagging' a record) to get started...

For purposes of example, consider an "Employees" table, (you can apply this concept to any table in your db, as needed).

- Add a yes/no field called 'Inactive' to your table to flag people who are no longer employed at your company.

- Add a checkbox to your Employees form, bound to your Inactive field.  Call the checkbox chkInactive

- In your form's design view, right-click the Employee Name textbox (or whatever field you want to 'flag' with a color), and select Conditional Formatting...

- Select "Expression Is.." from the drop-down list and type this expression in the textbox provided:
                     [chkInactive] = True

Then choose a backgound color, text color etc for highlighting the employee's name.

If done correctly, that will highlight/flag employees who are 'Inactive'.
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 38354042
<just dont know where to start. >
You can search here or Google/Bing...
LVL 75

Expert Comment

by:Anthony Perkins
ID: 38355566
Topics: Microsoft Access Database, MS SQL Server
Please drop MS SQL Server topic, it does not apply.

Author Closing Comment

ID: 38369675
Thanks Guys!

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

873 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