Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Checkbox in word document

Author  Topic 

vc56522
Starting Member

11 Posts

Posted - 2005-07-20 : 17:32:17
I am populating word doc template through vb and database. In the word doc
there is a 'yes and no' checkbox. and I bookmark it box as txtyes and txtno and
in the database there is Field called chkbox and it would have either yes or no
in it.

When I populate the word doc, I want it to check the corresponding field, right
now it just writing the word I WANT IT TO CHECK THE BOX NOT RIGHT THE WORD
YES/NO.

This is what I have:
If Rs_Data.Category = "No" Then

InsertTextAtBookmark oWord, oDoc, ("txtNo"), Rs_Data.Category


Else
InsertTextAtBookmark oWord, oDoc, "txtYes",Rs_Data.Category


How do I make so it would check the box according to what is in the database

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2005-07-20 : 19:22:01
Have you checked in the Word help if checkboxes support checked/unchecked?

What I would do is remove the checkbox and simply populate the bookmark with either a tick or a cross (from the extended characters).

Go to Top of Page
   

- Advertisement -