Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Display a checkbox field in a listbox

    There is a listbox on my form whose row source is a query.
    The source of the query is a table where the display control for a Yes/No field is a checkbox.

    The datasheet view of the query results, displays this Yes/No field as a checkbox. The listbox displays this Yes/No field as the text "Yes" or "No".

    How can I display the field as a checkbox in the listbox?

  2. #2
    New Lounger
    Join Date
    Jan 2001
    Location
    Great Lakes State, Michigan, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display a checkbox field in a listbox

    I hate to be the bearer of bad news but as far a I know there is no may to do this in an Access 97 list box (I'm not using Access 2000 yet so I don't know if can be done there). I use a third party ActiveX control to list data where I need to see the check box in a column of a list box.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Display a checkbox field in a listbox

    You can't do it in Access 2000 either.
    Charlotte

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Display a checkbox field in a listbox

    Could you use a subform instead of the listbox?

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Display a checkbox field in a listbox

    Or, if you're populating your listbox from a query, use a calculated field instead of the Yes/No field and use an expression like this to replace Yes/No with X or with a space:

    IIf([YESNOFIELD]=Yes,"X"," ")

    Then you would only have an X next to the ones that had a true value in the underlying field.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •