datasheet view convert -1 to "Yes" and 0 to "No"

[BennyLinton]

I have a datasheet form "frmExpiredSub" listing the results of a query. For one textbox called "txtExpired" the values are integer -1 and 0. I want to either have this textbox display "Yes" for -1 and "No" for 0 or make this textbox invisible and have another textbox "txtExpiredVisible" pickup the value from "txtExpired" and convert it to "Yes" or "No". Any ideas? I've tried to use case statements in the loading of the form but so far no luck. Thanks!

 

[Ranman256]

the boolean field can be formated to show YES/NO
or -1/0
or TRUE/FALSE.

in a query , set the format property of the field.

 

[almahmood]

Hi,

Use this formula:

IIF([txtExpired],"Yes","No")

 

[BennyLinton]

Thanks... that worked perfectly!