Printable View
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
Conver the numbers to text using an TO_CHAR and LPAD.Quote:
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:
How do I make the zeroes as well as the number fields with values right justified?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
regards
LPAD(TO_CHAR(Amount, '99,999,999.99'), 15)
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