Hi, I'm creatig a form by importing a file from Excel 2007 (w/form Wizard) on Acrobat 9.0 Pro and would like to know if there is a way for Acrobat to automatically know that I want some fields to be dates, others to be text, and others to be digital signatures. Is there some code or special text I can put in the Excel file spreadsheet cells so Acrobat will know I want I certain type of form field? It recognizes what areas I want as form fields with no problem, but I have to manipulate them to date/text/etc. Also, the major issue is the digital signature fields: I cannot toggle the form fields that Acrobat automatically creates into digital signature fields and when I try to just insert such a field, the alignment is way off. I've fiddled with modifying the properties of the form fields it automatically creates (Properties \ Format \ Custom format: Custom Format Scripts and Custom Keystroke Script) but cannot make it into a digital signature field. Any help would be greatly appreciated.
thanks, A
You might want to look at the power and features of OpenOffice.Org.
I have always found Excel to be a poor tool for creating forms.
George Kaiser