issue with row source of listbox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Associates - 12 Feb 2008 04:38 GMT

Hi,

I need help with the following issue.

In the form, i have a listbox whose row source made up of two different
tables.
In one of the field i set it up as follows

Expr1: IIf(Not IsNull([Subject_Name]) Or
[Subject_Name]<>"",[Subject_Name],[OldSubject_Name])

I was trying to get it to show up in the listbox in the view mode but to no
avail. Is it to do with the fact that it's not one of the fields exist in the
table?

How do i work around this?

Thank you in advance

Reply to this Message

John W. Vinson - 12 Feb 2008 06:14 GMT

>Hi,
>
[quoted text clipped - 10 lines]
>avail. Is it to do with the fact that it's not one of the fields exist in the
>table?

NULL is not unequal to "". It's not equal (or unequal) to anything!

Try

Iif(NZ([Subject_Name], "") <> "", [Subject_Name], [OldSubject_Name])

Better yet, don't use Allow Zero Length in your table unless you have one of
the VERY rare cases where you must do so, dragged kicking and screaming to
turn it on. That would let you just use NZ:

NZ([Subject_Name], [OldSubject_Name])

Signature

John W. Vinson [MVP]

Reply to this Message