MS Access form Listbox displaying 0/-1 instead of Yes/No
Posted on 2008-06-13
I have a peculiar problem.
Its related to MS Access 2003 and the .mdb file resides in a server.
I have a form which contains a list box and the list box is bound to a query. The query fetches records from tables. Two columns represents Yes/No field in the table.
When the application is run, two columns (out of several other columns) should display Yes/No.
The problem is, on some machines the list box column showing Yes/No and in some machines its displaying 0/-1.
Why is this unusual behavior?