FP2000: Regional Separators Prohibit Validation

View products that this article applies to.

This article was previously published under Q235000

Symptoms

When you specify comma format (2,55) as a data value in the Data Value field of the Form Field Validation dialog box, you may receive the following error message in your Web browser when you submit the form:

Please enter a value greater than or equal to "2,55" in the "fieldname" field.

Please enter a value less than or equal to "2,55" in the "fieldname" field.

↑ Back to the top

Cause

FrontPage does not recognize the comma as a decimal delimiter in the Value box of the Data Value section, even if the comma is specified as the decimal delimiter.

↑ Back to the top

Resolution

To resolve this problem, follow these steps:

In the Form Field Validation dialog box, select Numeric for data type.
Click to select the Comma option for Numeric Format. Note that there are two options for Numeric Format; Grouping and Decimal. This problem occurs using either format.
For the Data Value, click to select the Field Must Be: check box.
Click to select Greater Than or Equal To from the list.
Type a number in decimal format, using the period as the decimal delimiter. Example:

2.55

↑ Back to the top