Forced boolean checkboxes

[LadyMarmalade]

:banghead:

Simple question!

I have a field that is a 1/0 boolean. I simply want the result formatted as a "Yes/No".
It has worked for all the other fields in the table but this one is insisting on formatting as a checkbox and I can't figure out why - there doesn't seem to be any difference in the sittings.
Any suggestions?
Thanks!
Lady Marmalade

 

[CJ_London]

what it looks like in the table should be immaterial since users will be using forms, however you can change the view in table design by clicking on the fields lookup tab and changing the display control to text box and under the general tab set the format to yes/no.

 

[LadyMarmalade]

what it looks like in the table should be immaterial since users will be using forms, however you can change the view in table design by clicking on the fields lookup tab and changing the display control to text box and under the general tab set the format to yes/no.

I did give that a go - for some reason it's refusing to let me change it to text box. It has no issue with combo box however...

 

[gemma-the-husky]

just a note.

You say 1/0 Boolean. True False is not 1/0. True is minus 1 (-1) . I doubt if that is the issue, but worth noting.

 

[LadyMarmalade]

just a note.

You say 1/0 Boolean. True False is not 1/0. True is minus 1 (-1) . I doubt if that is the issue, but worth noting.

Sorry, I meant -1 - typo! The data is in the form -1/0 (and is being correctly recognised by the checkboxes at least)