I have a memo field that contains the character " / " to separate the text into categories. Specifically, it's book readings where each day has page readings from different sections of the book. My original intent was to create the readings and import them to Outlook which would then show up on my pda.
In my attempts, I have tried a number of ways outside of Access to have each section appear on its own line. In Excel I used the ALT+Enter scheme -- only to have it show up in Access and Outlook as a non printable character.
In the Access memo field itself, I can manually create the line breaks with CTRL+Enter and it correctly imports to Outlook with the line breaks. But I have about 300 rows with 5 categories -- too much manual intervention.
Appreciate the help!
In my attempts, I have tried a number of ways outside of Access to have each section appear on its own line. In Excel I used the ALT+Enter scheme -- only to have it show up in Access and Outlook as a non printable character.
In the Access memo field itself, I can manually create the line breaks with CTRL+Enter and it correctly imports to Outlook with the line breaks. But I have about 300 rows with 5 categories -- too much manual intervention.
Appreciate the help!