#type! error

[Sonyatwillis]

I have a field that contains two types of information; either a number (usually 111) or the word "RETEST". In my report I am trying to make the field for this print a "$" if it is a number and the word "RETEST" if it is not a number. I am using an unbound text box with the following code in the control source:



=IIf([Payment Amount]>1,"$" & [Payment Amount],"RETEST")

This works in as much that it puts the "$" in front of the number as requested, but for everything that is not a number, it says, "#type!". Any ideas on how to make this work?

Thanks!

[June7]

The table field is a text data type? Does the textbox have Format property set?

Try:

=IIf(IsNumeric([Payment Amount]), "$","") & [Payment Amount]