Floating Point DocVariable

[SeanP]

I have a DocVariable that I want to always show up with a Decimal. As of now
it cuts the decimal when it is a whole number. I didn't see a way to set it
to a floating point number or anything. How can I accomplish this? It has
to be simple, I am jsut not seeing it.

 

[Jay Freedman]

I have a DocVariable that I want to always show up with a Decimal. As of now
it cuts the decimal when it is a whole number. I didn't see a way to set it
to a floating point number or anything. How can I accomplish this? It has
to be simple, I am jsut not seeing it.

In the DocVariable field in the document, include a numeric picture
(\#) switch with the desired number of decimal places. For example, if
you want two digits after the decimal point, the field code should
look like

{ DocVariable MyVarName \#"0.00" }

 

[SeanP]

Oh yeah, but I am also trying to reference the DocVariable in a UserForm as
well, any way to make it show up in a textbox correctly formatted as well?

 

[Jay Freedman]

Hi Sean,

Yeah, it's simple if you know what to look for. The Format function in VBA
does the same trick as the picture switch in a field:

Dim ActualVar As String
ActualVar = ActiveDocument.Variables("MyVarName").Value
TextBox1.Text = Format(ActualVar, "0.00")

 

[SeanP]

That worked great, thanks so much. It actually turned out I needed both
methods. Thanks again.