IIF statement in Control Source

D

Dumb Blonde

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?
 
K

Ken Snell [MVP]

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

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")
 
K

Ken Snell [MVP]

thanks for the catch, Steve!
:)


--

Ken Snell
<MS ACCESS MVP>

Steve Schapel said:
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.
Click to expand...
Click to expand...
 
D

Dumb Blonde

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

Ken Snell said:
thanks for the catch, Steve!
:)


--

Ken Snell
<MS ACCESS MVP>

Steve Schapel said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Top