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.
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" ThenInsertTextAtBookmark oWord, oDoc, ("txtNo"), Rs_Data.CategoryElseInsertTextAtBookmark oWord, oDoc, "txtYes",Rs_Data.CategoryHow 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). |
 |
|
|
|
|