Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Dec 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Yes/No field Display as 0/-1 (Access 2003 / SR 3)

    Has anyone else seen that in Combo and List boxes on Windows XP Service Pack 2 that the Yes/No fields display as 0 and -1 instead of Yes and No?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Yes/No field Display as 0/-1 (Access 2003 / SR 3)

    Have you tried setting the Format property of the combo box to Yes/No or True/False? Without that, I see -1/0 in Access 2002 too.

  3. #3
    New Lounger
    Join Date
    Dec 2002
    Location
    Brisbane, Queensland, Australia
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Yes/No field Display as 0/-1 (Access 2003 / SR

    Hi Hans,

    I've not seen it in Access 2002, it seems to work fine for me.

    We also usually have multiple columns in both combo boxes and ListBoxes, so setting the format doesn't help.

    The benefit of multiple columns in ComboBoxes are for example.

    TitelID, TitleName, TitleCode, TitleType, TitleSetting, HasImage, IsComplete.
    You hide the ID field, but show the rest.

    So the combo shows only the TitleName but when they selecting the TitleName, they have more information about the Title to work with to make sure they have the correct one.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Yes/No field Display as 0/-1 (Access 2003 / SR

    You are correct. It is a bug that has been introduced with Access 2003 SP3, by now there are lots of reports on it.

    Let's hope that Microsoft will release a fix soon.

    In the meantime, there is only one clunky workaround I can think of: create a query that replaces the Yes/No field with a text column containing the word "Yes" or "No":

    TextField: IIf([YesNoField],"Yes","No")

    and use this query as row source instead of the original table or query.

Posting Permissions

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