On a one record data source (a table from an Access database) I'm having difficulty handling various Boolean data fields. The data field 'HasAnAddressYES' is false. There is another data field 'HasAnAddressNO' that is true. (I didn't design the system, I've been asked to maintain it.)
Anyway, here is the underlying merge code:
Code:
{ IF { MERGEFIELD "HasAnAddressYES" } "Yes address" "No address" }
on toggling the code, it reverts to this:
Code:
{ IF False "Yes address" "No address" }
And the result is "Yes address".
The problem is, the the Boolean data field is False, and therefore I want displayed "No Address".
Any advice appreciated.
Steve.