How do I change the back colour of a field displayed on a form in datasheet view

Posted on 2011-10-12
Last Modified: 2012-08-13
I've developed a Faults database - Access 2007.adp/SQL2008. I'm displaying all OPEN faults via a form in datasheet view. I'm trying to colour code the Elapsed Time (Hours and Minutes) of any OPEN fault that has been OPEN for more than 2 Hours in Red. If Under 2 hours then leave white. It would appear that when the form is loaded it takes the settings of the first record  as the default and colours all the displayed records as per the first record settings - see attached "FaultsProblem1.png". If I click on a specific record then it takes that record's settings as the default and applies them to all the displayed records see "FaultsProblem2.png".
What I would like to achieve is to set the back colour of each individual record displayed according to each records Elapsed Time. Is this possible or am I just wasting my time.
Many Thanks
Question by:Adlerm
    LVL 13

    Accepted Solution


    You cannot do it in datasheet view. But you can create an autoform and apply conditional formatting on the field.


    Author Comment

    Hi Sam
    Many thanks for your response. Two questions 1) What is an autform
                                                                                2) How do I create one.

    I'll go on line and see what I can find in the interim

    Author Comment

    Hi Sam

    Sorry about the delay. I've been trying to learn about autoform and have managed to get one working and do exactly what I as trying to achieve. There doesn't appear to be too much literature about autoform - especially on the internet - and I've still got a bit to learn especially how to modify the form generated (change column headings, put spaces between fields etc). Anyway I'm well on the way. I've never used this feature before so it good to learn something new.  

    Author Closing Comment

    Gave me a good lead into how I could over come my problem

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    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

    10 Experts available now in Live!

    Get 1:1 Help Now