Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Yes/No Options (2003)

    (Edited by HansV to provide link to post, using <!t>[post#=328424]<!/t> - see <!help=19>Help 19<!/help>.
    The post number seems to be incorrect, however)


    I have a problem with putting the results of a Yes/No box on a report. I want to put the result if 'Yes', as a large tick (a Webding font, using 'a'), but I'm getting a tick whether the result is yes or no. The report runs from a Query, and the query is giving the correct results. I've put a formula in the control that says '=IIF([MyTxt]=True,"a",""), but this does'nt work. Its a similar problem to <post#=328424>post 328424</post#>, only for a report, not a form

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

    Re: Yes/No Options (2003)

    What is [MyTxt] ?

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Yes/No Options (2003)

    The name of the Yes/No control in the report

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

    Re: Yes/No Options (2003)

    The MyTxt name suggests it is a text box. Is that correct? And if so, what does it contain?

  5. #5
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Yes/No Options (2003)

    Sorry, bout the confusion. My brains kicked in now. I was using a criteria for the wrong control, that's why it wouldn't work

Posting Permissions

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