Hide/Replace numeric value with text value

[gaker10]

I figured this was pretty simple, but I suppose not because I cannot figure it out nor find anything on this topic.

In my table, I have a field called PriceBreakEnd. When the user enters -1, that is a user defined value meaning an indeterminate amount. I generate a report based on a query I have, and this field is in my report. But, instead of displaying -1 for applicable records, I want it to say * instead for the report only, because it is a more intuitive/universal symbol for an indeterminate amount. PriceBreakEnd is formatted as a number. I've tried some code and Validation to no avail.

Is this possible to do or no?

[amrut]

In the query, add a field having value IIf([PriceBreakEnd]=-1,"*",[PriceBreakEnd])
or
In the report, hide the txtbox showing PriceBreakEnd ( say txtPriceBreakEnd )and use another text box with =IIf([txtPriceBreakEnd]=-1,"*",txt[PriceBreakEnd]) as control source

[gaker10]

The second suggestion was perfect!

Thank you!