I apologize if this has been asked before I have looked and can't find anything on the subject.
I am creating a requisition form that our company requires to obtain a Purchase Order number. Currently we have an excel version, and I am converting it to a PDF fillable form using LiveCycle Designer. I have created the entire form using LCD if that helps. The problem is in my currency fields. I have them set up as Decimal with Currency formatting applied, which results in the text appearing as "$X,XXX.XX" but what I need (Finance is asking for it this way) is to have the text appear as "$ X,XXX.XX", In Excel this is called Accounting style. Is there some way to format my cells this way?
you have to to two things.
1. Define the pattern for your numeric field.
Attention: There have to be a space after the currency symbol!!!
num{$ z,zzz,zz9.99}
2. Define the alignment of the numeric field, through a JavaScript in the exit event.
this.para.hAlign = "justifyAll";
All values will displayed then such as [$ 1.234,00] or [$ 1,00].
radzmar
• LoveCycle Blog
Documents you need:
• LiveCycle Designer ES2 Docs