I would like to do this so that the output on a report is an image rather than a word (ex. true/false)
Hello,
Please see my answer in this post → Conditional format for boolean in report
Edit:
For an actual image, include a link to the image in the record (embedded images in reports have been a long standing problem). Then use a conditional print expression (General tab of field property):
["myBool"]="true"
where myBool
is the boolean field to check.
Sample result:
Edit #2:
Also, if the image is constant, you can simply insert in using properties (Graphics property):
What if I need it to show an image instead of a character?
How do I include a link to the image in the record
? do i add another field in the table for that? or another table? Sorry, I am very new to these stuff. I only learned about base through thefrugalcomputerguy.com.
NVM, I’ve figured it out thru multiple tries. And I am very much thankful for the answers you’ve given me. You’re solution only works if both your answer (the link and your post) was combined. Adding an “if” function in the data field in the data tab, then afterwards inserting an image with the conditional print expression you suggested made it work for me. Thank you so much.