Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    May 2002
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Yes/No Field on Report (2000)

    Hi all,

    I made a yes/no field and didn't realize that it would show -1 and 0 on my report. Is there anyway to force it to show Yes or No through code, or do I just need to change my original field?

    Thanks!
    Sarah

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Yes/No Field on Report (2000)

    If you use textbox for Yes/No field, and don't specify format, a -1 (True) or 0 (False) will be displayed. Recommend specify Format property for textbox in report Design View, the three options available are: True/False; Yes/No; On/Off. Then when report is viewed or printed, one of the specified formatting text strings will be displayed instead of -1 or 0.

    HTH

  3. #3
    Star Lounger
    Join Date
    May 2002
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Yes/No Field on Report (2000)

    Great! Thanks!

Posting Permissions

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