Value -1 instead of Text (Access2000-03)

[MS_fan]

Trying to extract field from the datatype text field
Status: (IIf([STATUS_CODE]='010',"Open",[STATUS_CODE]) Or IIf([STATUS_CODE]='100',"Hold",[STATUS_CODE]))

Getting -1 value.
Please, look this up.
I had tried to change datatypes but no avail.

[HansV]

Try

Status: IIf([STATUS_CODE]='010',"Open",IIf([STATUS_CODE]='100',"Hold",[STATUS_CODE]))

[MS_fan]

Hooray! Thanks