Formatting Checkbox Output

stretch

New member
Local time
Today, 19:43
Joined
Feb 5, 2003
Messages
9
I have a form which contains a checkbox along with some other Yes/No Controls. The form updates a table.

When I run queries on the table, the value shown for the checkbox is always either -1 or 0 - now I understand that is correct, but is there any way to display that as yes or no in in the actual datasheet view of the query - reason is - I don't do much more with the datasheet - it is just exported to an excel spreadsheet, for other people to use.

Any help greatly appreciated !
 
Use a calculated field
ChkBx:Iif(MyField,"Yes","No")
 
neileg said:
Use a calculated field
ChkBx:Iif(MyField,"Yes","No")


Fantastic - works perfectly .....

Now - all I've got to do is think of a natty quote to put under my signature !!
 
Now - all I've got to do is think of a natty quote to put under my signature !!
How about "In theory, there's no difference between theory and practice, but in practice there is"
 
neileg said:
How about "In theory, there's no difference between theory and practice, but in practice there is"


Well it beats the thoughts I had so far - was looking at these two :

"No plan survives first contact with the enemy"

or

"There is no problem that cannot be solved by the application of High explosives"
 

Users who are viewing this thread

Back
Top Bottom