Originally posted by ranjini
Dear All,

In Form Builder, while displaying in the LOVs, how can I align the number fields? The number fileds aligned looks like the example given under:
Code:
Code Desc      Amount      Optr

 5   AAA    4,555,265.56   DFLT
 7   BBB            0.00   DFLT
 9   CCC    3,505,123.75   DFLT
11   DDD            0.00   DFLT
How do I make the zeroes as well as the number fields with values right justified?

regards
Conver the numbers to text using an TO_CHAR and LPAD.
LPAD(TO_CHAR(Amount, '99,999,999.99'), 15)