Conditional Formatting - Currency to Number (possible?)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In conditional formatting of a control on a report, I only see option to Bold, Underline, Change Font Color Etc
I am wanting to change the format from Currency to a Number when a certain criteria is met
It looks like this is possible, but I don't have a selection in the window to do this?
 
Kelly said:
In conditional formatting of a control on a report, I only see option to Bold, Underline, Change Font Color Etc.
I am wanting to change the format from Currency to a Number when a certain criteria is met.
It looks like this is possible, but I don't have a selection in the window to do this?
Click to expand...


Not using CF. Use code in the section's Format event.

If thecondition Then
Me.thecontrol.Format = "Currency"
Else
Me.thecontrol.Format = "#,##0.00 "
End If
 
Back
Top