How to fix new line error in Microsoft Word 2013 QR code?

Try changing the QRCode field type to Memo.

Trust me Doug, I've used up all the guesses -- I'm looking for a solution. I am using Access 2013 which has short text and long text as string field datatypes. The memo datatype is from an older Access version.

I can produce what you are after, if I have the following data in an Excel workbook

and I use the following field construction in a Word document:

Note the carriage returns indicated by the ¶ and that I had to use a formatting switch to get the currency format in the QR Code (as with any mail merge).

Here is the resulting QR code:

which scans into the required output of:

2001 Sangiovese
Brunello di Montalcino "Castello Banfi"
Poggio Alle Mura, Montalcino, Italy
750 ML 14% ALC
$65.00

An interesting observation: I have an app called QR Droid on my Android phone. Scanning the QR code with that app, the text appears on the phone without any line breaks; but after uploading the text to DropBox and opening it on my Windows PC, the line breaks were there.

Thank you Jay for confirming my problem.

Thank you Doug for providing your reconstruction in Excel. I tried building my QR code using your method as well with no success. I was wondering which QR code reader you are using because I tried a half-dozen QR readers on your QR code and I consistently get ignored carriage returns just like my problem.

The reason I suspect a Microsoft bug is this:

-Go to http://www.qrstuff.com/

-Select the "Plain Text" radio button and paste-in a block of text with carriage returns.

-The resulting QR code SHOWS the carriage returns in all my half-dozen QR readers.

I'm surely missing something because either Microsoft is doing a non-standard implementation, or QRstuff.com is doing it all right.

Any other wisdom will be highly appreciated.

Doug, which versions of Excel and Word are you using for this implementation?

Thank you. Mike

Mike,

I used Office 2013 and I scanned the QR Code with QR Code Reader on a Windows 10 Phone and here is a photo of the output on that phone

However, I just now tried with an application of the same name that I installed on an Google Nexus and with that, the line breaks were ignored.

So it appears that the QR code reader also had an influence.  There are lots of them out there and I guess I just got lucky with the first one I picked for the phone and missed out in the case of the Google Nexus.

Thanks, again, Doug! That's great news. I'll keep searching for the right combination of apps.