Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

ACCESS DATABASE MERGE TO WORD WITH YES/NO WONT FUNCTION

Copper Contributor

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