I have a database field that is a Access yes/no pick field. Stores the data as either 0 or 1 and will display the data as either 0 or 1 or True or False. Any suggestions as how to display it as Yes or No. The Field is for information/display purposes only and will not changed by the user

Wm. Kent Steelman

Hi

You could try using a text field instead of a yes/no field, set your default value to whichever one you want (Yes or No) and then on the web page that you are using to enter/update records have a drop down list containing the 2 values, that then updates this field in your db.

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

easily done with a little conditional statement.

where you normally display the recordeset code for the checkbox, use this instead.



<pre id=code><font face=courier size=2 id=code>
&lt;% Dim ValueShow
ValueShow = <b>rsYourRecordsetName</b>.Fields.Item("<b>CheckBoxName</b>".Value %&gt;
&lt;%If ValueShow = "True" Then
Response.Write ("Yes"
Else
Response.Write("No"
End If %&gt;
</font id=code></pre id=code>

^^ changing bold text to whatever you need it to read.

Regards,
Dave

UD4 | Flash 5/MX | Studio MX | SQL | Access | ASP/VBScript | XP-Pro