Iif Function Help

[mpaulbattle]

I have a form where the Record source is a query. One of the records is a checkbox for PrimaryFac. When we export this form to excel this field shows as true or false. We would like it to show Primary or blank. I was thinking maybe we had to show this on the form before exporting to excel. So I created an unbound textbox and entered in the control source:

=IIf([PrimaryFac]="True","Primary"," ") ... this does absolutely nothing.

Am I missing something?

 

[Minty]

Nearly

The True shouldn't be in quotes. Try

=IIf([PrimaryFac] = True , "Primary"," ")

 

[mpaulbattle]

Awww...that worked. Thanks