What's wrong with my formula?

[Anne Troy]

Basically, if there is anything in the empcontractorname field, it should show it.
Otherwise, I don't want to see anything.
It's a textbox on a form that has the same fields elsewhere on the form.

=IIf([empContractorName]="","","Business: "&[empcontractorname])

It doesn't want to work for me. I either see "Business: " when I shouldn't or I don't see anything, and I should.
Any help? Thanks so much in advance! I'm so rusty with Access.

 

[petertenthije]

Could you try this?
=IIf([empContractorName]=null,"","Business: "&[empcontractorname])

 

[jackd]

You may wish to review the IsNull function.

 

[stumac]

An easier way for this should be to use a + rather than &.

="Business: " + [empcontractorname]

The + operator supports null propagation therefor if your field is null the entire expression will return null.