Aligning number fileds in Oracle Forms Builder

[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 Desc Amount Optr

5 AAA 4,55,265.56 DFLT
7 BBB 0.00 DFLT
9 CCC 3,05,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

[gandolf989]

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 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)

[ranjini]

Dear All,

The conversion method mentioned above, was also tried before and it gave me the alignment as

Amount
4,55,658.90
0.00
22,565.80

etc like this. The alignment mentioned in my first thread was after converting the number field with the conversion that was mentioned in the reply. Is there some other way, which will align the number fields? This lpad(to_char(amt,FM)) works fine in the SQL prompt, with the correct alignment. But it doesnt work fine with the Form Builder.

regards
ranjini