Yes/No Problem !

[BonKeri]

Hello,

I have a problem with Yes/NO data type , I'm interested to make e column in yes/no data type and
in format field properties i wrote ;"PO";"JO"


and if I'am in datasheet view if i write Po and i want to see "PO" and if i write Jo i want to see "JO"
I know i can do it with -1 and 0 , but im interested to write "Po" and "Jo" and want to see them PO and JO

Can anybody help me please ?

[ssanfu]

You would have to change the field type to Text to have "PO" or "JO".

The YES/NO data type can use -1/0, TRUE/FALSE or (sometimes) YES/NO. The TRUE/FALSE and YES/NO are constants in VBA to represent -1/0, which is why "PO/JO" won't work.
Actually, FALSE is equal to Zero and TRUE is NOT Zero (any number other than Zero - doesn't matter if value is .01, -1, 1 or 2000).