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

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

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?
 
Charles W said:
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?
Click to expand...

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.
 
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?
Click to expand...

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