Use Space instead of Decimals

Hi @kathyb80271993,

Hope you are doing well. Thanks for writing in!

If you are still looking for a solution, here’s how you can achieve this:

Step 1: Configure the Field Format with a Custom Script

1. Open the form in Acrobat.
2. Select the field you want to format.
3. Open Properties (right-click the field and choose "Properties").
4. Go to the Format tab.
5. Select Custom Format Script and enter the following

if (!isNaN(event.value) && event.value !== "") {
    // Replace the decimal point with a space in the displayed value
    event.value = event.value.toString().replace(".", " ");
}

Step 2: Ensure Calculations Are Not Affected

For fields that involve calculations:

1. Perform all calculations using the numeric values (with decimal points) in JavaScript.
2. Use a Custom Format Script in the fields displaying the results to apply the formatting.

Example for an auto-calculated field:

1. Go to the Calculate tab of the field where the result is displayed.
2. Add your calculation (e.g., Line 1 - Line 2).
3. Then, in the Format tab, use the same custom script to replace the decimal point with a space:

   if (!isNaN(event.value) && event.value !== "") {
       event.value = event.value.toString().replace(".", " ");
   }
   

Step 3: Optional - Validate Input

To ensure users always enter values with two decimal places:

1. Go to the Validate tab.
2. Use the following script to validate the input:

   if (!/^\d+(\.\d{2})?$/.test(event.value)) {
       app.alert("Please enter a valid dollar amount with two decimal places.");
       event.rc = false;
   }
   

To be Noted:

1. Hard-Coded Decimal Points on the Form: The script ensures that only the display value is affected. Calculations and data processing will continue to use the standard numeric format with the decimal point.
2. Alignment Issues: Using a space instead of a decimal point might cause slight misalignment if the font in the form fields doesn’t handle spaces and numbers uniformly. Test with different fonts or field alignment options to improve visual consistency.

This approach keeps the decimal-based calculations functional while presenting the values with space as required.

Let me know if you need further assistance!