Results 1 to 5 of 5

Thread: Checkbox issue
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2009
    Posts
    163
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Angry Checkbox issue

    Hi All,
    This may be easy for some but I have looked around and can't see an answer to my issue.

    I have created a form with a number of checkboxes and when I pull the data from access into excel in a table format all the details from the check boxes show ether False or True.

    Is there anyway that a check box can display 0 for false and 1 for true

    Kind Regards as always

    P

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    75,157
    Post Thanks / Like
    Mentioned
    62 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Checkbox issue

    How are you pulling the date into Excel?
    If posting code please use code tags.

  3. #3
    Board Regular
    Join Date
    Jun 2009
    Posts
    163
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Checkbox issue

    Quote Originally Posted by Norie View Post
    How are you pulling the date into Excel?
    Hi
    I am not sure if the correct term but I am going to the data tab in XL and clicked on from access in the top left and corner to allow me to get external data selecting the axis file for the data source.
    I then choose table and put the data in the worksheet
    I hope this makes sense

  4. #4
    Board Regular
    Join Date
    May 2013
    Posts
    655
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Checkbox issue

    Export as csv and import to Excel
    Office 2007
    Access novice. Sometimes trying to give something back

  5. #5
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,703
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Checkbox issue

    maybe the Access table field is formatted as Yes/No? Not sure if Excel would still do the same if it was True/False. Would probably not if it was integer, which is really the best choice for TRUE/FALSE, YES/NO, ON/OFF regardless. Can the spreadsheet column format not be modified so suit?
    EDIT - in Access 0 is false, -1 is True. In expressions and vba, anything other than 0 will be treated as True.
    Last edited by Micron; Jul 13th, 2019 at 05:00 PM.
    Tips for posting problems:
    1) "doesn't work" doesn't help. Post error message text/numbers and/or state what's happening.
    2) if posting code or sql, use code tags; specify on which code line errors occur, if applicable
    3) try to be specific; assume we know nothing about your issue - because we don't!

    Make all suggested changes in copies of your database or to its objects.

    "1 out of 1010 people understand binary. The other 1001 don't."

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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