View Single Post
 
Old 12-21-2020, 02:31 PM
gmaxey gmaxey is offline Windows 10 Office 2016
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

For formfileds, you will have to create a custom procedure and call in when you exit the formfield (see the formfield properties dialog):

Private Sub FormatInput()
Dim oFF As FormField
Set oFF = ActiveDocument.FormFields("Text1") 'Your formfield bookmark name.
If Not oFF.Range.Text Like "####-###-####" Then
If IsNumeric(oFF.Range.Text) And Len(oFF.Range.Text) = 11 Then
oFF.Range.Text = Format(oFF.Range.Text, "####-###-####")
Else
MsgBox "Please enter an eleven digit ID"
End If
End If
End Sub
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote