Changing textbox's decimal places on report open

[rstrong]

Hey,
I have an invoice report that I need to sometimes display currency to 3 decimal places but most of the time display 2 decimal places. I have the code to determine when 3 decimal places are needed and when 2 are but I am not sure how to change the textbox's format properties when the report opens. Any ideas? Thanks.

 

[Remou]

How about:

Private Sub Report_Open(Cancel As Integer)
Me.FieldX.Format = "$#,##0.000"
End Sub