Tip Two questions regarding memo field (1 Viewer)

[Larry Kates]

1. I have been told that the memo data type is "unstable", and should not be used. Does anyone have experience with memo fields corrupting the database?

2. I would like to have the format of the text typed into a memo field be retained (ie: CRLF, blank lines). Is there a way to do this?

 

[georgedwilkinson]

1. I have used a memo field in exactly 1 project. I have had no problems. Is there a reason to believe there would be a problem?

2. Text is text. CRLF is text. If it get saved to the database that way, it will come out of the database that way.

 

[DCrake]

On the form that updates the memo field do you have the keyboard behaviour set to "New Line in Field"

This will retain all line feeds etc

 

[PaulO]

To create a new line and/or blank lines press the CTRL and ENTER keys together at the point you wish to break the text up ...