Change colors for flagged people

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.

-Thanks
CMILLERAsked:
Who is Participating?
 
mbizupCommented:
<< 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'.
0
 
Jeffrey CoachmanMIS LiasonCommented:
<just dont know where to start. >
You can search here or Google/Bing...
0
 
Anthony PerkinsCommented:
Topics: Microsoft Access Database, MS SQL Server
Please drop MS SQL Server topic, it does not apply.
0
 
CMILLERAuthor Commented:
Thanks Guys!
0
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.

All Courses

From novice to tech pro — start learning today.