Conditional Formatting a Data Access Page

[rdog0505]

I currently have a database created that works great for what I use it for, but it was requested that I make a small change to the data access pages that i have created from this database. The pages display information from the database and what they would like is for when one of the numbers is below say 85% to conditionally format it to change to red background. I have tried to find this information and figure it out online, but so far I have not been successful.

I am attaching a sample of the database I am using. I have changed some of the information just so that I am not exposing any information from the company that may not be good to expose. The sample data access page will likely be needed to be relinked before it will work properly on anyone elses system.

Basically what I need to do is conditionally format "Efficiency" for each of the records so that when it comes up below 85% the background of the text box turns red. If it is above 85% i want the background green. This is suppose to be a fast visual indicator letting people know if things are going well or not.

Any help would be greatly appreciated.

View attachment Production Tracking.zip

 

[rdog0505]

Still looking for any help possible with this issue.

Thanks.

 

[boblarson]

Still looking for any help possible with this issue.

Thanks.

I wish you luck in finding someone who can help but I have to warn you that the great majority of people here have not used Data Access Pages and since they have been removed from Access in 2007 and above, it is going to get harder and harder to find anyone with that type of experience. Plus you will not be able to upgrade or else you will lose the ability to work with them. And 2003's Mainstream Support ended last year and the Extended Support will only be available until 4/8/2014.

You might want to be exploring other options that may be possible.