Rich Text memo field carriage return

[Guest]

I am trying to script a Carriage Return into a new Rich Text formatted memo
field.
When I set the memo field to:
"something" & vbcrlf & "something else"
I just get: somethingsomething else
The rtf format that I would use for carriage return is "/par" (I believe).
But if I script it:

"something" & /par & "something else - it doesn't recognize /par
"something" & "/par" & "something else"
gives me: something/parsomething else

Can anyone help, and point me to what I'm missing?

Thanks

 

[Rick Brandt]

I am trying to script a Carriage Return into a new Rich Text
formatted memo field.
When I set the memo field to:
"something" & vbcrlf & "something else"
I just get: somethingsomething else
The rtf format that I would use for carriage return is "/par" (I
believe). But if I script it:

"something" & /par & "something else - it doesn't recognize /par
"something" & "/par" & "something else"
gives me: something/parsomething else

Can anyone help, and point me to what I'm missing?

Thanks

If you are talking about the new "RTF" capability in Access 2007 it is actually
stored as HTML, not RTF. So I would imagine that you need <br> or to wrap the
preceeding text in <p></p>.

Looking at your text with a non-RTF control after typing a line-break manually
should indicate how Access normally handles it. Then you can do the same in
your code.

 

[Guest]

Thanks a lot. Just adding "<br>" did what I needed.