Access adds brackets to text in quotes in Iif statement

I have a query of 1 short text field.  If the field has the value "NOCOV" I want to return Null, otherwise I want the value in the short text field.  The problem is that Access add brackets around "N...