How do you format a single column in a list box?

I have a column that shows a number (an account ID). This is a new feature, so consequently, some accounts have no number, while others have one.

I'd like to substitue "NA" whenever an account ID is not present.

iif([AccountID] & "" = "", "NA", cstr([AccountID]))

That should do it.

Nick

Cookie, can you tell me where that line belongs?

Does it follow after I submit the rowsource?

You know, me.myList.rowsource = "fancySQL"

Then where does that line go?

Take a look at the attached db.

HTH o!

Nick

ThankX