I have a report that shows the increase or decrease % totals of 2 columns.
ex. =[a]/[a1]-1 = 35%
I want to place in front of the 35% an indicator that shows up or down based on the results. ex. Maybe an up or down clipart arrow or some form of up down indicator. Is there a way to do that?

cx,

One method:

Position a new TextBox - "txtUp" on your form. Font = WingDings3, DefaultValue = "h". Visible = False.
Position a 2nd TextBox - "txtDown" on your form. Font = WingDings3, DefaultValue = "i". Visible = False.
Place them on top of one another in the appropriate location on your report.

Use the DetailFormat [Event Function]:


If (Whatever Condition) Then
Me.txtUp.Visible = True
Me.txtDown.Visible = False
Else
Me.txtUp.Visible = False
Me.txtDown.Visible = True
End If


Wayne