FP2000: Regional Separators Prohibit Validation

ID: Q235000


The information in this article applies to:


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.
or
Please enter a value less than or equal to "2,55" in the "fieldname" field.


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.


RESOLUTION

To resolve this problem, follow these steps:

  1. In the Form Field Validation dialog box, select Numeric for data type.


  2. 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.


  3. For the Data Value, click to select the Field Must Be: check box.


  4. Click to select Greater Than or Equal To from the list.


  5. Type a number in decimal format, using the period as the decimal delimiter.


  6. Example:

    2.55


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: fp2k


Keywords          : kbdta 
Version           : WINDOWS:
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: July 14, 1999