How to Fix Acrobat Prepare Form Missing or Duplicating Signature Fields
Question details
The user needs to resolve an issue where Adobe Acrobat's Prepare Form tool incorrectly misses or duplicates signature fields in PDF files generated from Microsoft Access.

- Product
- Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Creating a fillable PDF form with signature fields using a document exported from Microsoft Access.
- Observed behavior
- Automatic form field recognition in Acrobat either misses intended signature areas or creates duplicate fields due to overlapping artwork, spacing issues, or complex layouts.
Ensure you have access to the original Microsoft Access database to modify the report layout if necessary, as simplifying the source file is often the most effective first step.
Simplify Source Layout and Manually Adjust Fields
Adjusting the original design in Microsoft Access and manually correcting the fields in Acrobat provides the most reliable fix for automatic detection errors.
Acrobat's automatic form recognition relies heavily on clear visual cues like continuous lines and adequate spacing. Overlapping graphics, tight margins, or complex structural elements in the Access export can confuse the detection tool, leading to duplicated or missed signature blocks.
Open your report in Access Design View. Ensure that signature lines and text boxes have clear spacing and do not overlap with other graphical elements or borders.
Save or export the newly adjusted report as a PDF file to ensure the underlying document structure is as clean and simple as possible.
Open the new PDF in Acrobat, navigate to the 'Tools' menu, and select 'Prepare Form' to let the software attempt auto-detection again.
If fields are still missing, select the 'Add a signature field' tool from the Prepare Form toolbar at the top, and drag it to the correct location on your page.
Click to select any incorrectly duplicated fields generated by the auto-detection process and press the Delete key to remove them.

Add Signature Fields Manually with WPS PDF
Avoid the frustration of unpredictable auto-detection algorithms. WPS PDF allows you to effortlessly add, adjust, and manage PDF signature fields on documents exported from any software, giving you complete control over your forms.
- 1. Open your PDF in WPS Office: Launch WPS Office and open the PDF file you originally exported from Microsoft Access.
- 2. Navigate to the Form tools: Click on the 'Form' tab in the top navigation ribbon to access the fillable form creation tools.
- 3. Add a Signature Field: Select the 'Signature Field' tool from the menu, then click and drag on the document to draw the field exactly where you need it.
- 4. Adjust and save: Resize the field to fit your layout, add any other necessary form fields, and save your document.

Frequently Asked Questions
Why does Acrobat create duplicate signature fields?
Acrobat's automatic field detection relies on visual boundaries like lines and boxes. If your source document has overlapping graphics, thick borders, or repeated design elements placed close together, Acrobat may interpret them as multiple separate form fields.
Can I turn off automatic form field recognition in Acrobat?
Yes. You can disable this feature by going to Edit > Preferences > Forms, and unchecking 'Automatically detect Form fields'. This prevents unwanted duplicates by forcing you to add all interactive fields manually.
Does the Microsoft Access export method affect PDF form recognition?
Yes. Using the native 'Export to PDF' feature in Access versus printing to a virtual PDF printer can create different underlying document structures. If one method causes severe auto-detection issues, trying the alternative method may yield better results.
How do I manually add a digital signature field in a PDF?
In your PDF editor's form toolset (such as Acrobat's Prepare Form or WPS PDF's Form tab), select the 'Digital Signature' icon, then click and drag your cursor over the document to draw the field to your desired dimensions.




