Reading in a number formatted as a string from a PDF form

[bell]

Hi All,



I am having a slight issue, and I hope someone can help me resolve this.

I made a PDF form, and I use a button on my Access form to read in the PDF fields into my database.

I saved the value "00300" into the PDF form, under the field name "DOC NO". When I open the PDF form file, I see that 00300 is actually in there.

BUT, when I read in the value into a string, I get "300" instead of "00300".

I used this code to read in the value:

currentPartNum = jso.getField("DOC NO").value

Where currentPartNum is a string and jso is a object.

So, my question:
Is there another field under getField (instead of value) that will give me the full string and not just the number?
Or was I supposed to change a setting in the PDF form so that it thinks the field is a string and not a number?

[June7]

I doubt the Value property has anything to do with the truncation of leading zeros. Value is probably default property which means could likely not even reference it and the output would be the same.

Is currentPartNum variable explicitly declared as a String type?

[bell]

Hi,

Yup I declared currentPartNum as

Dim currentPartNum As String

[June7]

Do you always want a 5-digit string?

Try:

currentPartNum = Format(jso.getField("DOC NO").Value, "00000")

[bell]

Yeah, I thought about doing that.

The field holds a part number. In general it is 5-digits, but in a rare instance it could be longer or shorter, so I want to find a way where it doesn't drop the leading zeros.

[bell]

I found my answer, apparently using Value is wrong...instead, I did

currentPartNum = jso.getField(temp).valueAsString

And all works well

[June7]

Okay, Value property did have something to do with this issue - it was wrong property. Glad you found solution and thanks for sharing it.