Trying to display a green downarrow or red uparrow depending on the value in the condition. 1

[Pack10]

I am having some difficulty getting an ascii character to print on a report.
I have two simple fields on the report, all i want to do is compare them and
display an uparrow in red or a down arrow in green depending on the value.

 

[dhookom]

Pack10,
What have you tried? Are you using the Wingdings font and conditional formatting?

Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

conditional formatting....it's displaying the correct value, either chr(94) or chr(118) but not the color.

 

[dhookom]

Please share your Condition Is expression from the conditional formatting.

Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

I got this to work, it is conditional formatting with the wingdings. Never used Wingdings before. But easy
once you get it.

 

[xmeb]

Could you post how to do it?

 

[yezleb]

I am working on a report in Access 2010. I have a calculated field which totals payments based on a calculated through date that is entered at the time the report is run. I also have another fied that calcuates a balance. What I am trying to do is put a text box next to the balance field that displays one of three messages based upon the value in the calculated field(s). If the total payments field equals a certain amount then "Text 1" should be displayed. If the value is not equal to that amount then it should look at the other calculated field (balance). One of two messages should be displayed based upon the value of the calculated field.

Any help would be greatly appreciated.

 

[dhookom]

I expect you could use an IIf() expression in the Control Source of a text box. It would help if you provided some control names and sample data.

Duane
Hook'D on Access
MS Access MVP