This will also work:

=IF(A1,"Apples","Oranges")

Biff

"AMY Z." wrote in message
...
Hi,
Formula is in B1:
=IF(A1="TRUE","Apples","Oranges")

A1 is connected to a CheckBox in a Form.

The problem:
B1 always shows Oranges even if A1 says TRUE.

Thanks for your time,
Amy