stumped on how to check or uncheck a check box in pdf form through vba

[kavya]

Using VBA in MS Access trying to prefill a pdf form...

I have the following code to prefill if it is text box, stuck on how to check or uncheck a check box based on a field value.


Dim AcroApp As Acrobat.CAcroApp
Dim pdDoc As Acrobat.CAcroPDDoc
Dim fcount As Long
Dim sFieldName As String
Dim Field As AFORMAUTLib.Field
Dim Fields As AFORMAUTLib.Fields
Dim AcroForm As AFORMAUTLib.AFormApp
Dim jso As Object
dim x as object
Dim answer As Integer


If (Dir("c:\namus_reader.pdf") = "") Then
MsgBox "Questionnaire files not found "
Exit Sub
End If


Set pdDoc = CreateObject("AcroExch.PDDoc")

If pdDoc.Open("c:\namus_reader.pdf") Then


Set X = jso.getfield("ch_agenow")
X.Value = yrsnow


Set X = jso.getfield("ch_ncicnumber")
X.Value = NCICnumber

 

[SkipVought]

You might want to post in forum705.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[xlbo]

Try setting the value to 1 / 0 or true / false

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[kavya]

Setting the value to 'Yes' or 'No' worked. Thanks