Round a form field within a table

[Loretta]

I want to round the input in a form field. In my table, cell B2 is a form
field and when I enter 2.75, I want it to round to 3. Is there a way to do
that without using a calculating field?

 

[Graham Mayor]

Assuming the formfield in the cell is a text form field named "Text1", the
following macro run on exit from that field will round the result
Change "Text1" to reflect the true name of the field.

Dim sText As String
With ActiveDocument.FormFields("Text1")
If IsNumeric(.Result) = True Then
sText = Round(.Result, 0)
.Result = sText
End If
End With

http://www.gmayor.com/installing_macro.htm


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>