i have created a database driven website but i have a problem. I have a check box which enables records to be flagged up in a query, but i can't get the value to display yes insted of true and no instead of false, can anyone help??? merry xmas all

Edited by - Derran on 29 Dec 2003 17:21:00

When you insert from the form to the database, rather than selecting the type of field (in the insert wizard) as Access Checkbox, select text. This way you can simply set the values of the checkbox as Yes or No rather than the default Access True False senario.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

Didnt read your request fully, Is the checkbox used on the search page or is it checked as part of the form insert?

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting

Edited by - bakerv on 30 Dec 2003 12:53:11

its not on a search page, ill try that, thanks