Please Note: This article is written for users of the following Microsoft Word versions: 2007, 2010, 2013, 2016, 2019, and Word in Office 365. If you are using an earlier version (Word 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Word, click here: Using Mandatory Form Fields.

Using Mandatory Form Fields

by Allen Wyatt
(last updated May 9, 2019)

5

Julia asked if there is a way, when designing forms in Word, to make a particular form field mandatory. In other words, making sure that the user must fill something in the field.

There is no setting that you can use to mark a field as mandatory, as you can in Access. But there are several ways to provide the same functionality. Perhaps the easiest method is to simply make sure that you set the appropriate "on exit" setting for the form field to run a macro. (Display the Developer tab of the ribbon, click the Design Mode tool in the Controls group, right-click on the field, choose Properties from the resulting Context menu, and use the Exit drop-down list to select a macro to run.) The macro could check to make sure the value provided within the field is within acceptable bounds. If not, then the macro could move the insertion point back to the field to request input or could prompt the user for the necessary information. The following is an example of a simple macro to do just this:

Sub MustFillIn()
    If ActiveDocument.FormFields("Text1").Result = "" Then
        Do
            sInFld = InputBox("This field must be filled in, fill in below.")
        Loop While sInFld = ""
        ActiveDocument.FormFields("Text1").Result = sInFld
    End If
End Sub

In this macro you would need to change the name of the field specified (Text1) to the name of the field you are using the macro with. This particular example checks to make sure that the user enters something—anything—in the field. Your macro, of course, could get much more specific in the checking it does.

For a more comprehensive approach, you could have the on-exit macros (if there is more than one mandatory field) set a system variable. When the user tries to save or close the form, the AutoExit macro could check the value of the variable, and if it shows there are mandatory fields not filled in, then a dialog box explaining the problem could be displayed.

All of these approaches, of course, will require extensive testing before implementing. You will need to decide the best course of action based on your needs, the data involved, and the type of users you have.

Note:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (8337) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and Word in Office 365. You can find a version of this tip for the older menu interface of Word here: Using Mandatory Form Fields.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Searching for Paragraph Marks and Line Breaks

Word allows you to search not for special characters that normally do not print such as paragraph marks and line breaks.

Discover More

Duplicating Drawing Objects

Need to duplicate a drawing object? It's easy to do if you use the same editing techniques you are already familiar with.

Discover More

Normal Words Flagged by Spell Check

What do you do when Word's spelling check marks some common, everyday words as wrong? Here are some ideas of places you ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

More WordTips (ribbon)

Creating Traditional Forms

Do you use Word to create printed forms? If so, here's some ideas and techniques you can use to make those forms look as ...

Discover More

Copying Form Field Contents

Are you developing a form with Word? In some instances it is advantageous to copy whatever is entered in a form field to ...

Discover More

Spell Checking Forms

Word may be used to create protected forms that limit where the user may input data. Normally spell checking is disabled ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is five minus 0?

2018-07-30 06:10:22

zf

I tried to do this:
(Right-click on the field, choose Properties, and use the Exit drop-down list to select a macro to run.)
But there is no property option when I right click:


2016-03-17 09:53:06

Renee Sauerbrey

I am looking for assistance in creating a string of documents which contain variable fields. For example, in WordPerfect I was able to create a string of documents for an informal probate that contained everything needed to file with the Court. Each time I entered a field called Client Name, the Client's name was entered even though it had only been typed once.

It appears in Word the field aren't named, but numbered. I frequently get run time errors etc. and revert to typing each document separately, which is very time consuming!


2015-08-09 18:29:35

Mark

You hit Alt + F11 to pull up the VBA editor. Then you insert that macro.


2014-09-29 13:10:55

Jesse

An excellent post, just wondering if you could expand on the more comprehensive approach you mentioned for checking multiple fields in a document template. I am trying to find a way to do essentially just that. I have a template where various fields are filled out manually or selected from a list and am hoping there is a macro I can have run on exit where it just prompts the user if they missed one or more spots where data should have been entered. Any help is much appreciated!


2014-08-04 19:31:36

Fran Hutchinson

Hi there,

This is exactly the information that I am looking for, but I am using MS Word 2010 which has a different menu structure to 2007. When I right-click on a field and go to Properties I don't get any options about Macros - please help!


This Site

Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.