ListBox Formatting

[tonytrini]

Hi,

I am using a multi column listbox to display records from a table. One of the table fields is a currency field.

How can I format the listbox to display two decimals instead of four for the currency field?

Thanks

 

[jimstarr]

You can use STR(currencyfield, 10, 2).

Jim

 

[tonytrini]

str() does not work with the listbox rowsource property.

eg: list1.rowsource = "table1.itemcode,str(sellprice,10,2)"
produces a syntax error.

 

[jimstarr]

You're right - very quirky. I got it to work in reverse order:

list1.rowsource = 'str(table1.sellprice,10,2),itemcode'

Jim

 

[jimstarr]

This was with rowsourcetype = 6.

Jim