>>>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.
>
>Hey ... where's my acknowledgement? :-) ROFL
After three acknowledgements before I figured by now it is public domain. :)
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope