List Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hello Randy.

Randy said:
[a listbox now displays the -1 or 0 instead of "yes" or "no"]
Click to expand...

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?

--
Randy Street
Rancho Cucamonga, CA


Wolfgang Kais said:
Hello Randy.

Randy said:
[a listbox now displays the -1 or 0 instead of "yes" or "no"]
Click to expand...

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".
Click to expand...
 
Hi Randy,

What's the SQL syntax for the listbox?

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

Randy said:
[a listbox now displays the -1 or 0 instead of "yes" or "no"]
Click to expand...
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".
Click to expand...
Click to expand...
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?
Click to expand...

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.
 
Back
Top