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

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

Try changing the QRCode field type to Memo.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
Screen shots by Snagit from www.techsmith.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
Screen shots by Snagit from www.techsmith.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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.
_____________________________
https://jay-freedman.info

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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

Thank you. Mike

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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.

Hope this helps,
Doug Robbins - MVP Office Apps & Services (Word)
dougrobbinsmvp@gmail.com
Screen shots by Snagit from www.techsmith.com

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

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

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated July 9, 2020 Views 1,232 Applies to: