Change format for yes/no field in report Access 2003 1

[dawnd3]

I have a concatenated field in a report that is a yes/no field. It is showing up as -1 and 0 instead of yes/no. What is the format code for changing yes/no fields? Here is the field so far: =IIf([ysnCurrentInvestor]="no",[ysnCurrentInvestor],[ysnCurrentInvestor] & "/" & FormatCurrency([curInvestmentLevel],2))

Thanks for your help,

Dawn

 

[Remou]

Do you mean:

Format(ysnCurrentInvestor,"Yes/No")

A yes no frield will never be equal to "No" (Text), it will be equal to 0 or False.

 

[dawnd3]

You are awesome! Thanks!!!

Dawn