Space_punct_dict = dict((ord(punct), ' ') for punct in string. In the third box, click Type text, and then type Hello.Building on answer the following allows to check also the format of the date, and split a string into year, month, day - all the above assumed one has year, month, day already. In the second box, click is not equal to. In the first box, click Select a field or group, and then select the field or group that the control is bound to.
The following example shows how to create a data validation condition to ensure that data typed into a text box control matches a specific value - in this case, the word Hello. Under If this condition is true, add a condition. In the Data Validation dialog box, click Add. On the Format menu, click Data Validation. The following table lists the Microsoft Office InfoPath 2007 controls that support data validation and whether they are available for browser-compatible form templates.Īvailable for browser-compatible form templates?Ĭlick the control that you want to add data validation to. List of controls that support data validation This is done to ensure that only numbers. Range Check Range check is a validation check which can be applied to numeric fields. Note: When users fill out forms by using a browser, they can quickly display a data validation alert by pressing CTRL+SHIFT+I. An easy validation check can be done to make sure that a value occurs only once in this fieldit doesn’t matter if there are thousands of records in the database, the check can be carried out just the same. Alerts cannot be displayed automatically for forms that are viewed in a Web browser, but users can still view the ScreenTip, and optionally display an alert containing additional information. You can have this explanatory text appear in a ScreenTip, and optionally allow users to display an alert that contains additional information, or you can have the alert appear automatically when a user enters invalid data. For example, when you add data validation to a control, you create explanatory text to be displayed when a user enters invalid data into that control. Some data validation features work differently in a Web browser than they do in InfoPath. When you design a browser-compatible form template, some controls are unavailable in the Controls task pane because they cannot be displayed in a Web browser. When a browser-compatible form template is published to a server running InfoPath Forms Services, and then browser-enabled, forms based on the form template can be viewed in a Web browser. When you design a form template in InfoPath, you can choose a specific compatibility mode to design a browser-compatible form template. When you click the link, the alert appears. The pointer changes to a hand when you move it to the ScreenTip.ģ. However, users can display the alert by clicking in the field on the Web page that contains the ScreenTip, and then clicking the link that appears.Ģ.
When you click Full error description, the alert appears.įor a form that is filled out in a Web browser, alerts cannot be displayed automatically. When you right-click the field, a shortcut menu appears - and when you point to Full error description, the pointer changes to an arrow.ģ.
The pointer changes to an I-beam when you rest it over the field, and the ScreenTip is displayed.Ģ. For example, if you specify an error condition that you want to occur if a user types their name into a box that is used for collecting phone numbers, you can enable a ScreenTip to display the message "Type a telephone number in this field." If you enable an alert to appear automatically, you can show a detailed message by default, such as "This field requires a telephone number in the format (555) 555-0100." If you choose to display a ScreenTip by default, your users can manually display the alert that you provide by right-clicking the field in InfoPath, and then clicking the option to show the alert.ġ. Alternatively, you can set the detailed alert to be displayed automatically.
After viewing the ScreenTip, your users can optionally display a detailed alert that you provide. Ways that users are notified about validation errorsįor a form that is designed to be filled out by using InfoPath, you can set a data validation message to be displayed as a ScreenTip. Users can save a local copy of the form, and then correct and submit the data later. If a form contains data validation errors, and it is connected to a database or Web service, users won't be able to submit the form until they fix these errors. For example, you can use data validation to let users know when the amount that they enter for an expense item exceeds the approved amount, or when they mistakenly enter their name in a box that is used for collecting phone numbers.
By adding data validation to controls in your form template, you can ensure that the data that you collect is accurate and consistent, and that it conforms to any standards that are already in use by your company. Data validation is the ability to automatically check for errors while the user fills out a form.