MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Conditional Formatting in Access 2003

  Asked By: Steven    Date: Nov 26    Category: MS Office    Views: 981

i have a question

I have a form in Access 2003. There is a command button in the form.
If I click that button it will run a macro. The macro will open a
query in Pivot table view. That is the reason i have a macro (to open
the query in pivot table view and not in the default datasheet view).

Okay. My question is . I have a data field called "Compliance
Percentage". I would liked to apply conditional formatting on this. If
the % is between 90-100 it should be colored in Green, 80-90 should be
in orange and <80 should be in red.

Can anyone help me how to do this? if there is an easier way too, can
you please let me know.



2 Answers Found

Answer #1    Answered By: Raquel Austin     Answered On: Nov 26

This is a very Access specific question. It is well off topic for an Excel
VBA group. I would suggest you ask it on an Access forum.

In principle, I would expect that you could append something to the end of the
macro which

Divides one control by another
Sets the background color of the relevant control according to the result.

This is if you are using controls on a form. If you are opening and viewing
the query directly I do not think it will be possible to apply a conditional

Answer #2    Answered By: Alarice Miller     Answered On: Nov 26

Access has conditional  formatting just like Excel. You select the label in your
form and then I believe under the edit dropdown is conditional formatting.

Didn't find what you were looking for? Find more on Conditional Formatting in Access 2003 Or get search suggestion and latest updates.