Quick Code question for word form (Word 2000)

Topic

New Reply

Post deleted by NYIntensity

Reply | Quote

Replies

By “form” do you mean a Word document with form fields (from the Forms toolbar), or a VBA UserForm?

Reply | Quote

Post deleted by NYIntensity

Reply | Quote

Forms with form fields can be difficult to control. You can create a macro that warns the user and set it as Exit macro for the text field and for the check box, but this will not force the user to fill in the text box.

Sub TestAndWarn()
If ActiveDocument.FormFields(“Check1”).CheckBox.Value = True And _
ActiveDocument.FormFields(“Text1”).Result = “” Then
MsgBox “Fill in the text box”
ActiveDocument.Bookmarks(“Text1”).Range.Fields(1).Result.Select
End If
End Sub

This will not even reselect the text box if you tab out of it.

Reply | Quote

Forms with form fields can be difficult to control. You can create a macro that warns the user and set it as Exit macro for the text field and for the check box, but this will not force the user to fill in the text box.

Sub TestAndWarn()
If ActiveDocument.FormFields(“Check1”).CheckBox.Value = True And _
ActiveDocument.FormFields(“Text1”).Result = “” Then
MsgBox “Fill in the text box”
ActiveDocument.Bookmarks(“Text1”).Range.Fields(1).Result.Select
End If
End Sub

This will not even reselect the text box if you tab out of it.

Reply | Quote

Post deleted by NYIntensity

Reply | Quote

By “form” do you mean a Word document with form fields (from the Forms toolbar), or a VBA UserForm?

Reply | Quote