>>Hi all,
>>
>>I have table with some logical fields. When I designed a report, I need to put a check mark (like V or X) for each logical field if its value would be true or leave there a blank in otherwise. I tried to use the Print When expression :
>>
>>IIF(mytable.myfield = .T., "V", " "),
>>
>>However, the output was only empty spaces at all. Can anybody here give me some ideas, codes to get this problem worked? Any suggestions would be great appreciated.
>>Thanks in advance.
>>
>>Pearl.
>
>I agree with what the others have said about putting the code in the expression. You can alos get a true check mark to print by doing the following:
>
>Set the report field font to "Wingdings" and in the code behind the field:
>
>IIF(mytable.myfield, CHR(252), "")
>
>Which gives a check mark when true and blank when false.
It's not just WingDings; Symbol CHR(214) is a nice checkmark (nice useful collection of math symbols, Greek alphabet and arrows, too!) Both Symbol and WingDings should be present on pretty much any system as standard fonts.