Arrows as A Conditional Format

  • Thread starter Thread starter ryanp37
  • Start date Start date
R

ryanp37

I have a report that depicts the way in which a value compares to
another value. Specifically, it compares sales one year versus the
prior year and the prior year etc.. I would like to insert an up arrow
or a down arrow into the report that shows whether the sales %
comparison is up or down relative to the prior years comparison. I
dont see a way to do such a thing in the confitional formatting menu.
Any suggestions would be greatly appreciated.
 
You can create a text box with a control source like:
Control Source: =[Sales2005]-[Sales2004]
Format: \á;\â;""
Font: Wingdings
 
I have a report that depicts the way in which a value compares to
another value. Specifically, it compares sales one year versus the
prior year and the prior year etc.. I would like to insert an up arrow
or a down arrow into the report that shows whether the sales %
comparison is up or down relative to the prior years comparison. I
dont see a way to do such a thing in the confitional formatting menu.
Any suggestions would be greatly appreciated.
Click to expand...

Add an unbound control to the report where you wish the arrow to
appear.
Set it's control source to:
="á"
(You can simply copy this expression from this message and paste it
into the control source.)
Set it's Font to Wingdings
Set this control's Visible property to False
Name this control "ArrowUp"

Add another control.
Set it's control source to
="â"
(Copy and Paste this one also)
Set it's Font to Wingdings
Set this control's Visible property to False
Name this control "ArrowDown"

You can then code the Report's Detail Format event to make one or the
other control visible according to what ever criteria you want.

ArrowUp.Visible = [SomeControl]>[SomeOtherControl]
ArrowDown.Visible = [SomeControl]<[SomeOtherControl]
 
This has been quite an education. Thanks so much for the
assistance!!!!
fredg said:
I have a report that depicts the way in which a value compares to
another value. Specifically, it compares sales one year versus the
prior year and the prior year etc.. I would like to insert an up arrow
or a down arrow into the report that shows whether the sales %
comparison is up or down relative to the prior years comparison. I
dont see a way to do such a thing in the confitional formatting menu.
Any suggestions would be greatly appreciated.
Click to expand...

Add an unbound control to the report where you wish the arrow to
appear.
Set it's control source to:
="á"
(You can simply copy this expression from this message and paste it
into the control source.)
Set it's Font to Wingdings
Set this control's Visible property to False
Name this control "ArrowUp"

Add another control.
Set it's control source to
="â"
(Copy and Paste this one also)
Set it's Font to Wingdings
Set this control's Visible property to False
Name this control "ArrowDown"

You can then code the Report's Detail Format event to make one or the
other control visible according to what ever criteria you want.

ArrowUp.Visible = [SomeControl]>[SomeOtherControl]
ArrowDown.Visible = [SomeControl]<[SomeOtherControl]
Click to expand...
 
Back
Top