format in datagrid

[drmike]

Once again I have to apologise for the question!

I have a field that is a BIT so it's 0 or 1

It appears in a datagridview as a column

All I want is for a Yes/No entry in that column!

I thought it would be format="Yes/No" but obviously not.

In the immediate window ? format(1,"Yes/No") gives Yes and in VB6 (yes I know) format="YES/NO" worked but no more!

Please help to maintain the little sanity I have remaining.

Mike

 

[kulrom]

Maybe you can check it out before populate this column
If it's 0 then add a No otherwise add Yes.

 

[drmike]

Yes I could presumably do something like that in the SQL statement but it's not really very convenient nor desireable as we haven't decided if it will be an SQL server database or Access and the two systems require different SQL to achieve this.

Are you telling me that in your experience what I want to do can't be done?

Mike

 

[kulrom]

No. I am telling you what i would do in this case.
Btw, it doesn't matter whether you work with MSAccess or MSSQL. The SQL query is pretty same except if you want to use SP or something that MSAccess lacks of it.

 

[drmike]

Does Access support CASE? I can never recall. I thought there was CAST and CONVERT as well.

However, as you suggested I have used CASE to make the entries as required. Crude but effective.

Mike