Tick box values

[Martin]

I am outputting values from an access form to a word
document using some simply VB code. One field I am using
is a yes/no tick box. The problem with this is that it
only either outputs the values -1 or a 0. I want to output
the tick symbol or not as the case maybe not the -1 or 0.

I sure that this will be easy to somebody who know what
they are doing. The code I am using is below.

Thanks in advance

Martin

Appword.Selection.GoTo wdGoToBookmark, Name:="bmkOne"
If IsNull(Me.phOne) Then
Appword.Selection.TypeText ""
Else:
Appword.Selection.TypeText Me.phOne
End If

 

[Glenn]

Martin,

I am no expert, but you could try:

Appword.Selection.GoTo wdGoToBookmark, Name:="bmkOne"
If IsNull(Me.phOne) Then
Appword.Selection.TypeText ""
Else
Appword.Selection.InsertSymbol Font:="Symbol",
CharacterNumber:=-3882, Unicode:=True
End If

Glenn.