I have a problem with conditional formating, and have read some posts bit not sure there is a solution.
I want to set the background colour of my fields to red if a value in on of the fields is a certain value. The form in question is a sub form on a main form in a datasheet view (Problem the same even if not a sub form). record set is based on a query with only 500 records.
I have set up condistional formating and this is working, however displayed form flickers and moving mouse affect the results, takes a few seconds to apply the condition.
If I set the condition to only one field the problem is reduced and almost acceptable, with just a second or two delay as I move donw the datasheet.
This appears to be a problem with conditional formatting and I can not see a way around this using code.
Does anyone have a work around ?
Regards Neill H
I want to set the background colour of my fields to red if a value in on of the fields is a certain value. The form in question is a sub form on a main form in a datasheet view (Problem the same even if not a sub form). record set is based on a query with only 500 records.
I have set up condistional formating and this is working, however displayed form flickers and moving mouse affect the results, takes a few seconds to apply the condition.
If I set the condition to only one field the problem is reduced and almost acceptable, with just a second or two delay as I move donw the datasheet.
This appears to be a problem with conditional formatting and I can not see a way around this using code.
Does anyone have a work around ?
Regards Neill H
