Hi

I am struggling with something and was wondering if anyone could help.

I have an access database in which have a Yes/No field (which is diplayed as a checkbox in the database).

When I put the value of field on my page it gives a <b>True</b> or <b>False</b> value. How can I get it to display 'Yes' or 'No' on my page instead?

Also when I create a Insert Record page or and Update Record page I get an error, saying

Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

Please help, this is making my head hurt :S

Many Thanks

Paul

Edited by - pdg123 on 04 Jul 2002 15:01:27

If you want the page to show yes or no according to the database checkbox being checked or not you can use a code that says: "if the databse field checkboks is checked write yes otherwise write no." like this...

&lt;% If rsYourrecordset.Fields.Item("nameofdatabasefield" = True Then %&gt;
YES
&lt;% Else %&gt;
NO
&lt;% End If %&gt;

Hope this helps

Thanks I'll give that I try when I have a minute

Paul