I am creating an MS Access front end for data from somewhere else.
In this case, it's a linked SQL Server table.
The data is actually imported from a shared-hosting LAMP web server.
It's the results of an online quiz from a Wordpress page, from a plugin (wp-pro-quiz).
I'm going crazy because I simply want to view the data in this one column as plain text, but with line breaks.
But Access is ignoring the line breaks in the data.
I'm in a Form because I'm doing other data entry tied to this info.
I've tried it with a Textbox or a Label -- both are ok because I don't want to edit this column itself.
I keep checking with different tools that there are line break characters.
I also have tried editing the data by using a Textbox and pressing Ctrl-Enter.
This gives me a line break on the screen.
I swear when I check the data in a text editor the characters are the same as from my table. Aaargh!
What does Access want to be happy and show my line breaks from the table?