New line in a memo field

[Gkirkup]

When I am displaying a memo field, is there any way that I can force a new line? Can I add a character to the text to do that?

Robert

 

[missinglinq]

...When I am displaying a memo field, is there any way that I can force a new line? Can I add a character to the text to do that...

A little confused, here. Are you speaking of a Memo Field being displayed on a Form? You can force a line feed, while entering data into a Textbox that is bound to a Memo Field, by simply hitting the <Enter> Key. The Enter Key Behavior Property of the Textbox has to be set to 'New Line in Field,' but this is the Default when a Memo Field is placed on a Form. The Memo Field will then be displayed, on the Form, with the line feeds in place.

Linq ;0)>

 

[Gkirkup]

I am not typing into the memo field. I am taking fields from a record and adding them to the memo field, which is then displayed on a form. So my question is, how do I force a new line? It's been a while since I worked with CHR() values. Would CHR(13) force a line feed?

 

[jdraw]

I would concatenate the intrinsic constant vbCrLF, carriage return line feed, to the text as you add these pieces into the memo field.

 

[missinglinq]

...I am not typing into the memo field. I am taking fields from a record and adding them to the memo field, which is then displayed on a form...

Would have been helpful to us, in trying to help you, if you had given us this information in your original post! As jdraw said, vbCrLF should do just fine, here.

Linq >

 

[rzw0wr]

You may want to change the field Text Format to Rich Text and use HTML for this.

I think a new line in HTML is <br /> I think.
Got this from the web.

Dale

 

[Gkirkup]

Thanks, that worked well.

 

[rzw0wr]

We are happy to help.
Hope you continued success on your project.

Dale