#1
|
|||
|
|||
Boolean data field - how to correctly handle it
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" } Code:
{ IF False "Yes address" "No address" } The problem is, the the Boolean data field is False, and therefore I want displayed "No Address". Any advice appreciated. Steve. |
#2
|
||||
|
||||
Seems rather strange to have two data fields for the same thing.
Regardless, from your description, it seems you should be able to use: {IF{MERGEFIELD HasAnAddressYES} = TRUE "Yes address" "No address"}
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
Cross-posted at: Word Mailmerge : Boolean data field - how to handle it | Microsoft Answers
For cross-posting etiquette, please read: A message to forum cross posters - Excelguru
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
Thank you, cross-posting issue noted. The other forum is the primary thread.
|
Tags |
boolean |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Returning Boolean | Bikram | Word VBA | 4 | 04-04-2022 07:39 PM |
Loop through Multiple Boolean Variables | ScottyBee | Word VBA | 8 | 03-25-2019 03:24 PM |
Merge field source data field | kckay | Mail Merge | 4 | 03-25-2013 11:06 AM |
Mail Merge: cannot display the field in Excel correctly | derricklo1980 | Mail Merge | 5 | 08-16-2012 07:15 PM |
Mail Merge: cannot display the field in Excel correctly | derricklo1980 | Excel | 1 | 08-16-2012 12:51 AM |