Print nothing when zero

[uoghk]

in my invoice report, i use textbox to print the invoice amount (with 2 decimal places).


how to print nothing if invoice amount is 0 ?
in addition, how to print invoice amount with 2 decimal for normal clients, but only 1 decimal for some specific clients?

[June7]

Can use conditional IIf() expression in textbox.

Why would an invoice amount be 0?

How would you identify those "spcecific" clients?

[uoghk]

invoice amount is 0 because it is free of charge.

Clients may be ClientType either "VIP" or "NORMAL"
then how to print 1 decimal point for VIP, 2 decimal points for NORMAL ?

[Gicu]

In the Format or Print event of the report section containing the textbox for the invoice amount add something like this:

If Me.ClientType="VIP" Then
   Me.InvoiceAmount=Format (Me.InvoiceAmount, "#,#0.0")
Else
'Normal
   Me.InvoiceAmount=Format (Me.InvoiceAmount, "#,##0.00")
End If
'change font color to white if amount =0
If Me.InvoiceAmount=0 Then Me.InvoiceAmount.ForeColor=RGB(255, 255, 255)

Cheers,

[uoghk]

Thanks Gicu & June7