How do I replace all in a lookup for y/n (check) field?

[kqrbob]

I added a new yes/no field to my act 11 d/b and have a large lookup for which I want to change the value to yes (checked). But when I use the replace/edit field function it doesn't have a dropdown and doesn't accept "yes" or "y" as a valid value.

 

[GLComputing]

Try:
0 for no
1 for yes

Regards,
Mike Lazarus
ACT! Evangelist
GL Computing, Aust

http://www.GLComputing.com.au

http://blog.glcomputing.com.au

Join the LinkedIN ACT! Fanatics Group

http://www.linkedin.com/e/gis/49896

 

[kqrbob]

Thanks. Turns out True with a capital T also works (for yes).