Adlerm
asked on
How do I change the back colour of a field displayed on a form in datasheet view
Hi
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
FaultsProblem1.png
FaultsProblem2.png
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
FaultsProblem1.png
FaultsProblem2.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
Gave me a good lead into how I could over come my problem
ASKER
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