Hello,
I am trying to encode a Microsoft Access record into a Microsoft Word 2013 QR code. Using Access VBA, I format the record fields of my database with new lines (vbCrLf) into another field QRcode of type long text with the result like this:
2001 Sangiovese
Brunello di Montalcino "Castello Banfi"
Poggio Alle Mura, Montalcino, Italy
750 ML 14% ALC
$65.00
It looks perfect in Access, but when I mail merge my Access records into Word 2013, the resulting QR scan looks like this (no new lines):
2001 SangioveseBrunello di Montalcino "Castello Banfi"Poggio Alle Mura, Montalcino, Italy750 ML 14% ALC$65.00
In Word 2013, to generate the QR codes I use:
{ MERGEBARCODE QRcode QR \s 50 \q 3 } // size=50% with max error correction
I get everything I want in the unique QR codes -- except for the new lines. I've also tried Chr(13), ChrB(13), Chr(12), ChrB(12), etc. to no avail. I see no difference with or without Unicode Compression (I DO use upper ASCII characters in French and Spanish names).
Does anyone have a solution to this problem?
Thank you very much.
Mike