How to Remove Zero Values from Acrobat Percentage Fields
Question details
The user needs a way to keep a PDF percentage form field blank when the entered value is zero, as the default formatting forces the zero to be displayed.
- Product
- Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Creating or modifying an interactive PDF form where displaying '0%' creates visual clutter, and blank fields are preferred for zero inputs.
- Observed behavior
- Acrobat's built-in percentage formatting continuously displays a zero or reformats the value unexpectedly instead of leaving the field blank when zero is entered.
Ensure you have the necessary editing permissions for the PDF form and that JavaScript is enabled in your PDF viewer settings to allow custom scripts to run.
Apply a Custom Format Script to the Field
Bypass the default percentage formatting by using a custom JavaScript snippet that returns an empty string when the field's value is zero.
Since Acrobat's built-in percentage format does not offer conditional behavior to hide zero values, you must replace it with a custom format script. This script will check the inputted value and dynamically clear the display if it detects a zero, while perfectly formatting all other numbers as percentages.
Open your document in Adobe Acrobat, go to the 'Tools' menu, and select 'Prepare Form' to enable field editing.
Right-click the specific percentage field you want to modify and choose 'Properties' from the context menu.
In the Properties dialog box, click on the 'Format' tab located at the top.
Click the 'Select format category' dropdown menu and choose 'Custom' instead of 'Percentage'.
In the 'Custom Format Script' text box, enter a script that checks for zero. For example: if (event.value === 0 || event.value === '') { event.value = ''; } else { event.value = util.printf('%.2f%%', event.value * 100); }. Click 'Close' to save.
Edit and Manage PDF Forms Easily with WPS Office
WPS Office offers a comprehensive and user-friendly PDF editor, allowing you to fill, edit, and manage interactive PDF forms effortlessly without relying on heavy and expensive software.
- 1. Open Your PDF: Launch WPS Office and open your PDF document using the WPS PDF tool.
- 2. Access the Form Tools: Navigate to the 'Form' tab on the top ribbon to access interactive field editing.
- 3. Fill or Modify Properties: Click on any form field to fill in your data, or right-click to adjust field properties effortlessly.
- 4. Save the Document: Click 'Save' to preserve your interactive form data with full cross-platform compatibility.
Frequently Asked Questions
Why does Acrobat default to showing zero in percentage fields?
Acrobat's built-in formatting applies a strict mathematical mask to the field. When a field is defined as a percentage, it interprets an empty or zero value explicitly as 0.00% to maintain consistent numeric data formatting.
Can I apply this custom script to multiple percentage fields at once?
Yes. While in 'Prepare Form' mode, you can select multiple fields by holding down the Ctrl (or Cmd) key, right-click to open Properties, navigate to the Format tab, and apply the Custom Format Script to all selected fields simultaneously.
Does using a custom format script affect my calculation scripts?
No. The format script only changes how the data is visually displayed to the user. The actual underlying value of the field remains unchanged, so any separate calculation scripts referencing that field will still compute correctly.
Will the blank field still export as zero during data extraction?
If the underlying value entered was zero and your format script simply masks it visually, the field's actual value may still be extracted as zero depending on how you export the form data (e.g., to CSV or XML). If you need it to be completely null, a custom validation or keystroke script may also be required.
