By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,488 Members | 2,545 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,488 IT Pros & Developers. It's quick & easy.

Export to word check box problem

P: n/a
jpr
Friends,

I am having problems in exporting data from my Access db to a word
template.

On my form I have a check box named check1. On my word template a have
a box into which I need to export the value I enter in the check box.
My checkbox in word is bookmarked.

Something is not working proberly. The following code does not check
the box. Any help?

objWord.ActiveDocument.Bookmarks("check1").SelECT
If Not IsNull(Me.check1) Then
objWord.ActiveDocument.FormFields("check1").CheckB ox.Value = True
End If
objWord.ActiveDocument.Bookmarks("check1").SelECT
If IsNull(Me.check1) Then
objWord.ActiveDocument.FormFields("check1").CheckB ox.Value = False
End If

I have played around with the code, changing teh Null values to If
Me.check1 = "YES" etc... but still nothing.
Any idea?

Thanks.

Jun 7 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 7 Jun 2006 03:28:27 -0700, "jpr" <jp***@tin.it> wrote:

Sometimes a checkbox value must be 1 to be checked, not True (-1).
-Tom.

Friends,

I am having problems in exporting data from my Access db to a word
template.

On my form I have a check box named check1. On my word template a have
a box into which I need to export the value I enter in the check box.
My checkbox in word is bookmarked.

Something is not working proberly. The following code does not check
the box. Any help?

objWord.ActiveDocument.Bookmarks("check1").SelE CT
If Not IsNull(Me.check1) Then
objWord.ActiveDocument.FormFields("check1").CheckB ox.Value = True
End If
objWord.ActiveDocument.Bookmarks("check1").SelECT
If IsNull(Me.check1) Then
objWord.ActiveDocument.FormFields("check1").CheckB ox.Value = False
End If

I have played around with the code, changing teh Null values to If
Me.check1 = "YES" etc... but still nothing.
Any idea?

Thanks.


Jun 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.