Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office InfoPath
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Remove data validation
 

To prevent unwanted data validation (data validation: The process of testing the accuracy of data; a set of rules you can apply to a control to specify the type and range of data that users can enter.) alerts from appearing when users fill out a form, you can remove data validation conditions, change the data type (data type: Property of a field that defines the kinds of data the field can store. Examples of data types include Text, Rich Text, Whole Number, Decimal, True/False, Hyperlink, Date and Time, and Picture.), or change the control from required to optional.

ShowRemove data validation conditions

  1. In design mode, select the control whose data validation you want to remove, and then click Data Validation on the Format menu.
  2. In the Conditions with data validation list in the Data Validation dialog box, click the validation that you want to delete, and then click Remove.

ShowChange the data type

  1. In design mode, double-click the control whose data type you want to change.
  2. On the Data tab in the Control Properties dialog box, click the data type you want in the Data type box. The Text (string) data type allows users to enter any combination of text, numbers, and other characters, except rich text and images.

ShowChange a control from required to optional

  1. In design mode, double-click the control you want to change.
  2. On the Data tab in the Control Properties dialog box, clear the Cannot be blank check box.

Notes

advertisement