[AccessD] Byte values for Yes/No field showing

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. 




More information about the AccessD mailing list