ch******@gmail.com wrote:
At one of my client sites we noticed a few weeks ago that Listboxes
which previously showed "Yes" or "No" are now showing "-1" or "0". The
underlying tables and queries are displaying True/False fields
correctly and I suspect this problem is related to Service Pack 3.
I haven't been able to find any other posts on the Net about this
problem?
Has anyone else noticed this and more importantly, is there a solution?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I don't know what you mean by "The underlying tables and queries are
displaying True/False fields correctly...." (What's correct?) So, I
suggest you could change the ListBox's RowSource property to a SELECT
statement that includes an expression like this:
IIf(yes_no_column=-1, "Yes","No") As YesNo
for the table's Yes/No column (change the column name to your column
name).
If you allow NULLs in the Yes/No column (ugh) the expression would be
like this:
IIF(yes_no_column IS NULL,"UNK",IIf(yes_no_column=-1,"Yes","No"))
UNK stands for "unknown."
Relying on any control to "correctly" display the same format as the
source table is "iffy" at best. Who knows what may happen in the
future? It's always best to explicitly declare how you want the data to
be displayed.
--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBRwwtn4echKqOuFEgEQKSvQCdGcdd23rBWNTY4wNG3WYXeH 27K9wAoMzV
iX9aLbfsmMGN1J6h00t6pnan
=NFf6
-----END PGP SIGNATURE-----