INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

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

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

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

(OP)
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.

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

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

Duane
Hook'D on Access
MS Access MVP

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

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

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

Please share your Condition Is expression from the conditional formatting.

Duane
Hook'D on Access
MS Access MVP

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

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

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

Could you post how to do it?

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

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.

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

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close