Another option is to write a function to do this and an example below involves a case statement. In the color property of the textbox, you can reference the function like so:
=Code.GetColour(Fields!SubTotal.Value)
If you had multiple textboxes on a report that required the same colour formatting, this technique would be a bit more reusable.
Public Function GetColour(ByVal InputValue As Double) As String
Select
Case InputValue
Case 1000
GetColour = "Red"
Case 10000
GetColour = "Blue"
Case 30000
GetColour = "Green"
Case Else
GetColour = "Black"
End
Select
End
Function
No comments:
Post a Comment