I have a small problem with the values returned on my recorset. I am using a repeat region to show all regions held in a table. I have varied value currencies, ranging from 0.75p through to £30.

How can I format the values so that they appear: £0.75 and £30
Rather than: £0.75 and £30,000.00 ?

Try this:

<%
varPrice = rsName.Fields.Item("Price".Value
If varPrice <> "" Then
varLocale = SetLocale(2057)
varPrice = FormatCurrency(varPrice )
Response.Write("varPrice"
Else
Response.Write("& nbsp;"
End If
%>

Regards

Owen.

-------------------------------------------------------------------------------------------
Used programming books and web development software for sale (UK only): www.tdsf.co.uk/tdsfdemo/Shop.htm

Developer services and tutorials: www.drdev.net

Multiple Parameter UD4 / Access 2000 Search Tutorial: www.tdsf.co.uk/tdsfdemo/