[AccessD] Checkbox contents disappear in Word

    If you are very keen to show a tick mark in word document (in lieu of Yes values in Access report), you can try the following course of action:

    In Access report, use a special character like ~ in lieu of Yes value. Send the report to Word. In Word, save the exported rtf file as doc file. Then run the subroutine P_InsertCheckMarks() as given below. The cursor can be anywhere in the document when the procedure is run.

    This will result in replacement of all instances of ~ by a tick mark (√)

A.D.Tejpal
---------------

===============================
Sub P_InsertCheckMarks()
    ' Replaces ~ by Check Marks
    With Selection.Find
        .Text = "~"
        .Replacement.Text = ChrW(8730)
        .Forward = True
        .Wrap = wdFindContinue
    End With
    Selection.Find.Execute Replace:=wdReplaceAll
End Sub
===============================

  ----- Original Message ----- 
  From: Susan Harkins 
  To: 'Access Developers discussion and problem solving' 
  Sent: Tuesday, February 27, 2007 22:42
  Subject: Re: [AccessD] Checkbox contents disappear in Word

  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.