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

A.D.TEJPAL adtp at hotmail.com
Tue Feb 27 12:55:28 CST 2007


    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.



More information about the AccessD mailing list