>I have a list box with 2 columns using a table as the source. Is there a way to format the output of the list box? Specifically, the second column contains numbers that I would like to format like currency ($ and ,)
>Thanks!
Ken,
You can change the rowsourcetype to None and use the Requery method to populate the list with AddListItem calls. Your can then format the numbers using TRANSFORM( Field, "$999,999.99") in column two.