[AccessD] Checkbox contents disappear in Word:SOLVED???

Mark A Matte markamatte at hotmail.com
Tue Feb 27 13:09:12 CST 2007


Wow...Thank you very much for your gracious compliment...I wish I could take 
credit for the process...but I just searched for the right key words to find 
it.

Thanks,

Mark A. Matte


>From: "A.D.TEJPAL" <adtp at hotmail.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Checkbox contents disappear in Word:SOLVED???
>Date: Wed, 28 Feb 2007 00:25:28 +0530
>
>     That is an excellent solution Mark!  Much better & straightforward 
>than the work-around mentioned in my post.
>
>     My best compliments.
>
>A.D.Tejpal
>---------------
>
>   ----- Original Message -----
>   From: Mark A Matte
>   To: accessd at databaseadvisors.com
>   Sent: Tuesday, February 27, 2007 23:38
>   Subject: Re: [AccessD] Checkbox contents disappear in Word:SOLVED???
>
>
>   I thought this should be possible...so I googled "unicode checkmark vba" 
>and found an example...and it actually works and displays a check mark on 
>.RTF
>
>   Below are the steps and a link to the page where I found it.  Good 
>Luck...
>
>   Mark A. Matte
>
>   The steps
>   Open the report in design view.
>   If you already have a check box on your report, delete it.
>   Add a text box for your Yes/No field.
>   Set these properties:
>   Control Source: Name of your yes/no field here.
>   Font Name: WingDings
>   Width: 0.18 in
>
>   Type these characters into the Format property of the text box:
>   Hold down the Alt key, and type 0168 on the numeric keypad (the 
>character for False), semicolon (the separator between False and True 
>formats), backslash (indicating the next character is a literal),
>   Hold down the Alt key, and type 0254 on the numeric keypad (the 
>character for True),
>   You can now increase the Font Size, set the Fore Color or Back Color, 
>and so on.
>
>   The characters
>   Select the characters from this list:
>
>   Character Keypad number Description
>   Alt+0254 Checked box
>   Alt+0253 Crossed box
>   Alt+0252 Check mark (unboxed)
>   Alt+0251 Cross mark (unboxed)
>   Alt+0168 Empty box
>
>   http://www.everythingaccess.com/tutorials.asp?ID=Check-boxes-in-reports
>
>   >From: "Susan Harkins" <ssharkins at setel.com>
>   >Reply-To: Access Developers discussion and problem
>   >solving<accessd at databaseadvisors.com>
>   >To: "'Access Developers discussion and problem
>   >solving'"<accessd at databaseadvisors.com>
>   >Subject: Re: [AccessD] Checkbox contents disappear in Word
>   >Date: Tue, 27 Feb 2007 12:12:21 -0500
>   >
>   >When I really  needed it to say something besides yes and no, or 0 and 
>-1, I put an unbound box on the report and set the value in the Format 
>event of the detail section.
>   >
>   >=======The report will be published on the web, and I really wanted to 
>display the checkmarks, but I didn't know how to do it and retain them all 
>the way to the web.
>   >
>   >Susan H.
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Refi Now: Rates near 39yr lows!  $430,000 Mortgage for $1,399/mo - Calculate 
new payment 
http://www.lowermybills.com/lre/index.jsp?sourceid=lmb-9632-17727&moid=7581




More information about the AccessD mailing list