May 3 2005, 09:39 AM
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.
May 3 2005, 09:45 AM
iif([AccountID] & "" = "", "NA", cstr([AccountID]))
That should do it.
May 3 2005, 10:14 AM
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?
May 3 2005, 10:28 AM
Take a look at the attached db.
May 3 2005, 10:30 AM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here