dynamically formating a listview based on data type

[AppDev76]

Hi,
i have a listview that I populate using a recordset.
I need to format some fields,for example I have a currency field and a percentage field.
How can I get the datatype of the retuned field in the recordset so that I can format the field properly.

Thanks

 

[willir]

One way...
Use the format command in the SELECT statement...

SELECT Format(MySales, "$#,#0.00"), Format(MyMargin*100, "#00.0%")

or

strMyText = Format(MySales, "$#,#0.00")

Richard

 

[AppDev76]

Thanks