Forum Discussion
ISO20022-compatible QR Code
landste1 I think the problem is that the characters which create the line breaks are not visible to you but they are there. It may be that Access doesn't recognize whatever those line break characters are and therefore doesn't render them appropriately.
What I would do is try to parse the text string and figure out what they are.
George HepworthI did indeed parse the string using an online ASCII converter and a unicode converter that reveal non-printing characters, and the CR/LF codes were there just as they should be. I suspect that the problem lies not with Access itself, but with the MERGEBARCODE field in Word which generates the QR code from the Access DB. That seems to alter the CR/LF in a minor way which disturbs some QR readers but which doesn't show up in ASCII and unicode converters that reveal non-printing characters. It looks like it is something buried deep in the function code, and in that case I shall have to find another solution that doesn't use Word fields.
Thanks anyway for your interest and suggestions, it was encouraging that you tried to help me.