var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Format a column within a list box
I have a list box whose row source is being set by SQL, and I have three columns with numbers that I would like to format to look like "#,##0.00".
Is there a way to format specific columns in a listbox? It has five columns, and the ones to format are in 3, 4 and 5.
listbox.rowsource = "SELECT abc.trader, Sum(abc.daily_sales) FROM abc GROUP BY abc.trader"
needs formatting on the Sum(abc.daily_sales)
listbox.rowsource = "SELECT abc.trader, Format(Sum(abc.daily_sales), '#,##0.00') FROM abc GROUP BY abc.trader"