List Box won't display checkbox for yes/no feilds

[Guest]

I am trying to display a yes no field in a list box with 4 columns. When I
try to display the yes no field in the listbox it changes the format to the
text of the column (yes no or true false etc.) rather then the check box that
is displayed when you run the query or table. How can I change this?

 

[Dirk Goldgar]

I am trying to display a yes no field in a list box with 4 columns.
When I try to display the yes no field in the listbox it changes the
format to the text of the column (yes no or true false etc.) rather
then the check box that is displayed when you run the query or table.
How can I change this?

You can't, really. Access list boxes display text only. You could
conceivably use a third-party list control, or you could use a subform
set up to look and act like a list box.

 

[John Vinson]

On Fri, 14 Jan 2005 08:37:04 -0800, Charles W <Charles

I am trying to display a yes no field in a list box with 4 columns. When I
try to display the yes no field in the listbox it changes the format to the
text of the column (yes no or true false etc.) rather then the check box that
is displayed when you run the query or table. How can I change this?

You can't. A listbox is a list of text values; you cannot put other
types of controls (checkboxes, option groups, etc.) inside a listbox.

Consider using a continuous Subform instead.

John W. Vinson[MVP]