List Box

[Guest]

Hello,

Ok...this is kind of wierd...I have a list box that acts as a selection
window of sorts, meaning the info from the list box pulls data (applicants)
from let say the applicant table. When the list box is double-clicked it take
you to that applicants record (a separate form)...Now the problem I am having
has to do with the list box...the data in the list box contains the
applicants name, etc. and shows if they are "active" which is tied to a
checkbox (active_checkbox)...the listbox used to display (under the active
column) "yes" or "no"...for some strange reason the listbox now displays the
-1 or 0 instead of "yes" or "no"...

Any ideas as to how this might have changed and/or how I can change it back
to "yes" or "no" rather than "-1" or "0"?

Any assistance will be greatly appreciated. Thank you.

Randy Street
Rancho Cucamonga, CA

 

[Wolfgang Kais]

Hello Randy.

[a listbox now displays the -1 or 0 instead of "yes" or "no"]

Someone must have changed the format of the field in the underlying
table. Set the format property of the yes/no field to "yes/no".

 

[Guest]

Hi Wolfgang and thank you for your response. Just wanted to let you know that
the format property in the table is (and always has been) set to the Yes/No
option. Any other suggestions?

--
Randy Street
Rancho Cucamonga, CA

Hello Randy.

[a listbox now displays the -1 or 0 instead of "yes" or "no"]

Someone must have changed the format of the field in the underlying
table. Set the format property of the yes/no field to "yes/no".

 

[AccessVandal via AccessMonster.com]

Hi Randy,

What's the SQL syntax for the listbox?

Select col1, .... IIF("ThisColumn = -1", "Yes", "No") As ListBoxColumn ...
From sometable....

 

[Wolfgang Kais]

Hello Randy.

[a listbox now displays the -1 or 0 instead of "yes" or "no"]

Someone must have changed the format of the field in the underlying
table. Set the format property of the yes/no field to "yes/no".

Hi Wolfgang and thank you for your response. Just wanted to let you
know that the format property in the table is (and always has been)
set to the Yes/No option. Any other suggestions?

Maybe, someone changed the field properties in the query? Or is the
rowsource set via code? Maybe a new filter functionality has been
implemented? If not: I don't have other ideas.