Results 1 to 3 of 3
  1. #1
    crobaseball is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    128

    Yes/No Field, when active print text in a report

    I've got a "Made in the USA" yes/no toggle field in my database. When I go to print out the info in a report, I'd like for the report to recognize whether I have a true/false condition, and print out "Made in the USA" where appropriate? Suggestions? thx

  2. #2
    nigelbloomy is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2012
    Posts
    51
    I put an unbound text box on the bottom of my form. In the control source for the text box I put the following formula: =IIf(DLookUp("[ToggleField]","[MainTable]")=True,"Made in the USA","")

    It works for me. You could also add in criteria for the Dlookup so it can find a specific part number.

    Your report should be based on a query. You could also make a new field in the query and do an IIf statement like IIf([Toggle Field]=True,"Made in the USA",""). That way you would have the information in the query at the part level.

  3. #3
    crobaseball is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    128
    btw - I never responded . . .this worked like a charm. Thanks so much!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 09-17-2014, 08:23 AM
  2. Replies: 6
    Last Post: 03-01-2014, 07:07 AM
  3. Replies: 21
    Last Post: 01-21-2014, 05:04 PM
  4. Replies: 6
    Last Post: 02-02-2013, 12:44 AM
  5. Replies: 0
    Last Post: 07-15-2010, 12:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums