IIF statement in Control Source

[Guest]

I'm working on a report. The field is Member Type and is text. I've put
=IIf ([Member Type]="Associate","Associate"," ")
in the control source for the text box titled Member Type. I'm getting an
error for each record.

Basically, I only want it to print the member type if it's "Associate". All
others should be left blank.

What am I doing wrong?

 

[Ken Snell [MVP]]

Change the name of the textbox so that it does not have the same name as the
field. Perhaps txtMemberType.

 

[Steve Schapel]

Dumb Blonde,

Ken is correct in the solution to the error problem. I would just add a
further comment... According to your expression, if the Member Type is
not "Associate", you are trying to put in a space. Well, first of all
this won't work because Access will trim the space out anyway. You said
you want it to be "left blank", in which case I would suggest...
=IIf([Member Type]="Associate","Associate",Null)
or...
=IIf([Member Type]="Associate","Associate")

 

[Ken Snell [MVP]]

thanks for the catch, Steve!



--

Ken Snell
<MS ACCESS MVP>

Dumb Blonde,

Ken is correct in the solution to the error problem. I would just add a
further comment... According to your expression, if the Member Type is
not "Associate", you are trying to put in a space. Well, first of all
this won't work because Access will trim the space out anyway. You said
you want it to be "left blank", in which case I would suggest...
=IIf([Member Type]="Associate","Associate",Null)
or...
=IIf([Member Type]="Associate","Associate")

--
Steve Schapel, Microsoft Access MVP

Change the name of the textbox so that it does not have the same name as the
field. Perhaps txtMemberType.

 

[Guest]

Thanks to both of you! I knew it was something easy, I just couldn't figure
out what!

thanks for the catch, Steve!



--

Ken Snell
<MS ACCESS MVP>

Dumb Blonde,

Ken is correct in the solution to the error problem. I would just add a
further comment... According to your expression, if the Member Type is
not "Associate", you are trying to put in a space. Well, first of all
this won't work because Access will trim the space out anyway. You said
you want it to be "left blank", in which case I would suggest...
=IIf([Member Type]="Associate","Associate",Null)
or...
=IIf([Member Type]="Associate","Associate")

--
Steve Schapel, Microsoft Access MVP

Change the name of the textbox so that it does not have the same name as the
field. Perhaps txtMemberType.