yes/no listbox

[Vallan]

Hello.

Is it possible to change a value in a listbox?


I have a column in a listbox refering to a yes/no.

In the listbox it shows as 0 -1.

Is it possible to make it showin yes or no instead?



Matt

 

[KenHigg]

Make the row source a value list with Yes and No in it -

 

[Vallan]

Must be possible

Hi again.


If i have a listbox with 2 columns and one is a yes/no column.

in the listbox it shows like 0 and -1.


Somehow it must be possible to make the column to show the text instead (YES OR NO)


Maybe im wrong but i hope its possible.


Anyone who can give me a suggestion?

Matt

 

[WayneRyan]

Matt,

Base your listbox on a query:

Select Field1, 
       IIf([Field2], "Yes", "No")
From YourTable
Order By Field1

Wayne