Hi All,

I have a report in Access 2000 where I am working with two text boxes that I am trying to set some values for so essentially here is the scenario:

if textbox1=0 then I want textbox2 to display N/A
if textbox1=-1 then then I want textbox2 to display the value I have set as the control source for textbox2.

So how do I go about doing this?

Thanks so much!

Stacy

Try a control source of:

=IIf(OneFieldName = 0, "N/A", OtherFieldName)

That worked beautifully! Thank you!

No problemo!