Can I change my BIT column to receive YES or NO?

[michaaal]

Is there a way I can make BIT column able to receive "yes" or "no" values
instead of "-1" and "0" values?

I use the following code to create my database...

strSQL = "CREATE TABLE Inventory (ItemNumber TEXT(30), InStock BIT);"

....I am not interested in manually using MS Access to make this change
because my site creates new databases often. I am searching for a way to do
this dynamically.

Maybe something along these lines....?

strSQL = "CREATE TABLE Inventory (ItemNumber TEXT(30), InStock
BIT.UseYesNo);"

[Bob Barrows [MVP]]

michaaal wrote:

> Is there a way I can make BIT column able to receive "yes" or "no"
> values instead of "-1" and "0" values?

No. This is a display-format issue, not a database issue. You have two
choices:

1. Use vbscript to translate the 0 and -1 values to the values you wish to
display to the user
2. Use a CHAR field (Text if Access) and store the data as you wish to
display it.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.