Susan Harkins
ssharkins at gmail.com
Fri Apr 18 13:36:22 CDT 2008
The following code populates a list box: strSQL = "SELECT Title, Active FROM tblTopics WHERE " _ & rscriteria & " ORDER BY " _ & rsorder lstArticles.RowSource = strSQL The Active field is Yes/No, and instead of displaying Yes/No, the column display -1 and 0. I know I can populate the control using a query and resolve the problem, but I was wondering if anyone had a fix for this particular situation? Susan H.