in my access dbase i have a price field however when i call the field it displays the pound sign as a ?
is there a replace i can do so it displays as a £ or another way around it

<%=Replace(recordset.fields.item("fieldname".value, "?", "£"%>

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
&lt;%=Replace(recordset.fields.item("fieldname".value, "?", "£"%&gt;
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

ive tried that and it still apears as a ? aqny other suggestions ?

can you post the code from your recordset just so I can check that....

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]

&lt;%@LANGUAGE="VBSCRIPT"%&gt;
&lt;!--#include file="Connections/hottubs.asp" --&gt;
&lt;%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset"
Recordset1.ActiveConnection = MM_hottubs_STRING
Recordset1.Source = "SELECT * FROM specialtubs ORDER BY intid DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%&gt;
&lt;%
Dim Repeat1__numRows
Dim Repeat1__index

Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%&gt;
&lt;%=Replace(recordset.fields.item("fieldname".value, "?", "£"%&gt;
&lt;%
Recordset1.Close()
Set Recordset1 = Nothing
%&gt;

Adam,

Just to check, where you have the line

&lt;%=Replace(recordset.fields.item("fieldname".value, "?", "£"%&gt;

Do you actually have your recordset1 name where recordset is written and your fieldname where ("fieldname" is written?

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Adam,

Just to check, where you have the line

&lt;%=Replace(recordset.fields.item("fieldname".value, "?", "£"%&gt;

Do you actually have your recordset1 name where recordset is written and your fieldname where ("fieldname" is written?

Regards

Vince Baker
&lt;strong&gt;DMX Zone Manager&lt;/strong&gt;

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

apologies my fault the correct line is &lt;%=Replace(Recordset1.fields.item("strprice".value, "?", "£"%&gt;