Export to Word Bookmark

[jpr]

Hello friends, I have a good question for you.
I have a form in Access with a check box named chk1.
On the same form I have a code that export my data to a template in MS
Word. I use bookmark to export my access data. No problem with regular
data but cannot handle checkboxes. Basically I need help to export the
check box value (yes or no) into a check box places in my word
template. In this template I have a checkbox. If I doulble click in to
it I get a window which allows me to bookmark the checkbox but when I
export the access data, I will get a YES or NO priot to the checkbox in
word. Is there any way I can solve this problem?

This is a sample of my code:

objWord.ActiveDocument.Bookmarks("chek1").Select
If Err.Number = 0 Then
objWord.Selection.Text = Me.check1
Else
Err.Number = 0
End If

Is the probkem in the Selection.text?

Thank you.

[Cyrille]

Try using the "FormFields" Collection instead of the Bookmarks:

to tick the box :

objWord.ActiveDocument.FormFields("check1").CheckB ox.Value = True

that worked for me anyway,

--
Cyrille