Problem With IIf Statement

[Wayne]

I'm using the following IIf statement as the control source for a text
box on a report.

=IIf([WOnumber]=0,"",[WOnumber])

It works fine if "WOnumber" is numeric but gives an error if "WOnumber"
is alphanumeric. I don't understand this. If anyone can suggest a
fix, it would be appreciated.

[fredg]

On 17 Jul 2006 16:47:17 -0700, Wayne wrote:

I'm using the following IIf statement as the control source for a text
box on a report.

=IIf([WOnumber]=0,"",[WOnumber])

It works fine if "WOnumber" is numeric but gives an error if "WOnumber"
is alphanumeric. I don't understand this. If anyone can suggest a
fix, it would be appreciated.

If the field can be alphanumeric, then it is a Text datatype field,
not a Number datatype.

=IIf([WOnumber]="0","",[WOnumber])

Also, make sure the name of the control is not WOnumber.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Randy Harris]

* Wayne:

I'm using the following IIf statement as the control source for a text
box on a report.

=IIf([WOnumber]=0,"",[WOnumber])

It works fine if "WOnumber" is numeric but gives an error if "WOnumber"
is alphanumeric. I don't understand this. If anyone can suggest a
fix, it would be appreciated.

Probably this. You're comparing WOnumber to a number (0) which tells
Access to convert to a number. If it's alpha data, it can't. Obviously
it's not a numeric field. Are you actually storing a 0 in it?

If so, try:
=IIf([WOnumber]="0","",[WOnumber])

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[Wayne]

Thanks folks. I thought it would be something simple.