Microsoft Access 2000 Tips

Memo Field Text Formatting

Copying and pasting large text narratives into memo fields typically results in all the paragraph markers being removed or ignored, extra invisible characters being included that only appear in reports but not in form fields, and the like. This may be a Mac only problem, as I have not used the linux version in a number of years. The source of the text doesn't seem to matter, although text from any Microsoft Office application tends to include more and a wider variety of the invisibles. 

Using TextSoap <http://www.unmarked.com/textsoap/> ($40) to scrub the text prior to pasting it into the memo fields has pretty much fixed all the issues I was having. 

Remove Extra Spaces, Remove Forwarding Characters, Remove All Tabs, Remove Extra Returns

Works like a charm. 

by Unknown on 2009-09-17 14:44:45
Important Information Tips are provided by the CrossOver Community and Advocates. They are not intended to be used for official CodeWeavers Support. For that, please visit our official support pages.
CodeWeavers or its third-party tools process personal data (e.g. browsing data or IP addresses) and use cookies or other identifiers, which are necessary for its functioning and required to achieve the purposes illustrated in our Privacy Policy. You accept the use of cookies or other identifiers by clicking the Acknowledge button.
Please Wait...
eyJjb3VudHJ5IjoiVVMiLCJsYW5nIjoiZW4iLCJjYXJ0IjowLCJ0enMiOi02LCJjZG4iOiJodHRwczpcL1wvbWVkaWEuY29kZXdlYXZlcnMuY29tXC9wdWJcL2Nyb3Nzb3Zlclwvd2Vic2l0ZSIsImNkbnRzIjoxNzMxNDM1MjAzLCJjc3JmX3Rva2VuIjoidVZiaEVOelh3WnRLNmRrQyIsImdkcHIiOjB9