Change colors for flagged people

Posted on 2012-08-30
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 119

    Accepted Solution

    LVL 61

    Assisted Solution

    << 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
    <just dont know where to start. >
    You can search here or Google/Bing...
    LVL 75

    Expert Comment

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

    Author Closing Comment

    Thanks Guys!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    758 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now