Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-25-2022, 06:30 PM
saltwater saltwater is offline Windows 10 Office 2021
Novice
Boolean data field - how to correctly handle it
 
Join Date: Nov 2022
Location: Melbourne, Australia
Posts: 2
saltwater is on a distinguished road
Default 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" }
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.
Reply With Quote
 

Tags
boolean



Similar Threads
Thread Thread Starter Forum Replies Last Post
Returning Boolean Bikram Word VBA 4 04-04-2022 07:39 PM
Boolean data field - how to correctly handle it 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
Boolean data field - how to correctly handle it Mail Merge: cannot display the field in Excel correctly derricklo1980 Mail Merge 5 08-16-2012 07:15 PM
Boolean data field - how to correctly handle it Mail Merge: cannot display the field in Excel correctly derricklo1980 Excel 1 08-16-2012 12:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft