Home

ACCESS DATABASE MERGE TO WORD WITH YES/NO WONT FUNCTION

%3CLINGO-SUB%20id%3D%22lingo-sub-874655%22%20slang%3D%22en-US%22%3EACCESS%20DATABASE%20MERGE%20TO%20WORD%20WITH%20YES%2FNO%20WONT%20FUNCTION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-874655%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EAfter%202%20attempts%20on%20getting%20Microsoft%20support%20for%20my%20issue%20I%20was%20told%20it%20was%20too%20advanced%20for%20the%20consumer%20support%20so%20here%20I%20am!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20database%20with%20Access%20and%20added%20the%20function%20Yes%2FNo%20to%20some%20fields.%26nbsp%3B%3C%2FP%3E%3CP%3EIssue%20is%20when%20I%20merge%20to%20my%20Word%20document%2C%20the%20value%20Yes%2FNo%20will%20only%20appear%20as%20True%2FFalse.%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20change%20display%20control%2C%20row%20source%20such%20as%26nbsp%3B%7B%20IF%20%7B%20MERGEFIELD%20myyesnofield%20%7D%20%3D%20%22True%22%20%22Yes%22%20%22No%22%20%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStill%20only%20merges%20in%20word%20as%20True%2FFalse!%3C%2FP%3E%3CP%3EMy%20text%20book%20is%20dated%20from%202007%20so%20the%20ribbons%20have%20changed%20quite%20a%20bit!%3C%2FP%3E%3CP%3EPlease%20help%20me!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-874655%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-876466%22%20slang%3D%22en-US%22%3ERe%3A%20ACCESS%20DATABASE%20MERGE%20TO%20WORD%20WITH%20YES%2FNO%20WONT%20FUNCTION%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876466%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F415049%22%20target%3D%22_blank%22%3E%40SSCCLEAN%3C%2FA%3E%26nbsp%3B%20Take%20a%20look%20here%20%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fkb.iu.edu%2Fd%2Fahww%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fkb.iu.edu%2Fd%2Fahww%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
SSCCLEAN
Occasional Visitor

Hi there,

After 2 attempts on getting Microsoft support for my issue I was told it was too advanced for the consumer support so here I am!

 

I have created a database with Access and added the function Yes/No to some fields. 

Issue is when I merge to my Word document, the value Yes/No will only appear as True/False.

I have tried to change display control, row source such as { IF { MERGEFIELD myyesnofield } = "True" "Yes" "No" }

 

Still only merges in word as True/False!

My text book is dated from 2007 so the ribbons have changed quite a bit!

Please help me!!

 

 

1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies