06-15-2011 02:00 PM
I'm in the process of editing a custom layout and adding in a field for a checkbox. Instead of displaying (on the final, printed sheet) as Yes/No I want it to display either a check (big X?) or nothing.
Is this even possible? I've read every piece of literature I can find online/from our office but none of them make any mention of this. Any help would be appreciated
06-20-2011 08:27 AM
Welcome to the Sage ACT! Online Community!
There isn't a function available for making a yes/no field actually look and print as an X.
An alternate option would be to create the field as 'character', set the field length to '1' and, add the new field to the layout with appropriate dimensions to show a single character of data. Then simply enter an 'X' into the field for the contact. Your print would then show either the X or blank.
06-21-2011 08:19 AM
Good to know.
I tried this approach (http://kb.sagesoftwareonline.com/cgi-bin/sagesoftwareonline.cfg/php/enduser/std_adp.php?p_faqid=1380...) but it continues to display Yes, Y or an undefined character that looks like a box when I tweak the OnPrint Section Scripts.
Is there any way for me to get around the display of Yes or No for a substituted character instead?
06-21-2011 08:43 AM
OK you are referring to an ACT! report, that wasn't clear before. What I do is use a custom field and a VB "If" script to display what ever i want in the custom field based on the actual data in the database field. My preference is to substitute an uppercase X for Yes and leave it blank for No.
06-21-2011 11:23 AM
I've gone to the print out after editing the VB to reflect X for yes and blank for no and it still displays Yes/No, or a funny character if I get creative & try to use something like webdings to create a check instead.
Is the code in the link I provided above faulty or is this an error from elsewhere?
06-21-2011 11:47 AM
That Knowledge Base document needs updating. The information about chanracters is using Octal notation and Windows changed to using Hexidecimal codes for characters several years ago. I don't bother with the character codes but use and uppercase X. I think you're leaving out the custom field that you use for display rather than the actual database field.
06-24-2011 11:12 AM
Please check your private messages, upper right corner of the screen.