I use a database to enter my research on various pathophysiology. I enter my data in a table with about 12 fields. The data format of most of the data fields is memo (longvarchar). What I then do is this: when I'm working in a writer page, and I press "f4>navigate to database>select table>select record>insert record. The problem I have is the text in each field may be one paragraph or two or more. So the number of characters is always different (which is why I use memo instead of a set text limit).
What happens is it will insert all the contents of the field including the trailing spaces(which I don't want) at the end of the text for each field in the record. I want it to look like a normal document with various paragraphs and instead I usually get the paragraph, then two blank pages of carriage returns then the next field of the record so a document that should be 1-2 pages in length becomes 32 most of which is carriage returns down the page. How do I keep the blank space at the end of the entry from being inserted with the rest of the record? Any help is appreciated.
