IIf function in Microsoft Access 2000

  • Thread starter Thread starter Leslie
  • Start date Start date
L

Leslie

Good morning. I am trying to include the Iif function in
a report text box as follows:

=IIf([SEX]="F","Female","Male")

When I do this, I get an #Error message on the report
rather than Female or Male.

For some reason, since I have been using Access 2000, this
happens frequently when I try to use Iif. I used this
function routinely in Access 97 without any issues.

What am I doing wrong?

Thanks!, Leslie
 
Leslie said:
Good morning. I am trying to include the Iif function in
a report text box as follows:

=IIf([SEX]="F","Female","Male")

When I do this, I get an #Error message on the report
rather than Female or Male.

For some reason, since I have been using Access 2000, this
happens frequently when I try to use Iif. I used this
function routinely in Access 97 without any issues.
Click to expand...


Check the name of the text box, I'll bet it's named SEX. If
so, when you changed the text box's control source from a
bound field to an expression, you created a circular
reference (the expression refers to itself). Just change
the name of the text box to something else such as txtSex.
 
Make sure the name of the text box is not "SEX" (or the name of any other
field).
Using a name like "txtSex" would be like practicing safe sex...;-)
 
Check to make sure the table that SEX is on is populated
with data.....in that field, or make sure table is not
empty or it will give you an #Error on the report.
 
Back
Top