Forcing A New Line In Memo Field

[scott]

I have a memo-type textbox control on a form. On the form's OnOpen event,
I'm trying insert a few lines of text.

I'm having trouble forcing a new line after the 1st line is inserted. Is
there maybe an ASCII code that I could use inplace of the "vbCrlf", which is
not forcing a new line?

With my current code below, Access is only inserting the 1st line and
chopping off my 2nd line of text. I can manually force a new line when
typing by hitting Control Key + Enter, but so far, i've had no success doing
it with VBA.


CODE ***********************

Me.myMemoField= "1st Line: Text on line 1" & vbCrLf & _
"2nd Line: Text on line 2"

 

[Guest]

Scott, that line of code works perfectly for me on A2k, what version are you
using, have you tried vbnewline instead to try that?

TonyT..

 

[Marshall Barton]

I have a memo-type textbox control on a form. On the form's OnOpen event,
I'm trying insert a few lines of text.

I'm having trouble forcing a new line after the 1st line is inserted. Is
there maybe an ASCII code that I could use inplace of the "vbCrlf", which is
not forcing a new line?

With my current code below, Access is only inserting the 1st line and
chopping off my 2nd line of text. I can manually force a new line when
typing by hitting Control Key + Enter, but so far, i've had no success doing
it with VBA.


CODE ***********************

Me.myMemoField= "1st Line: Text on line 1" & vbCrLf & _
"2nd Line: Text on line 2"

Looks good to me. Is the text box tall enough to display
the second line?