how do i insert a carriage return in an access field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

the field is a Memo data type and i want to insert several lines of text
which will then be merged to a Word document
 
Hi Dennis,

I am afaraid i dont understand your short hand fully. Could you expand a bit
please.

Thanks Else

Dennis said:
[MemoFieldName] = "First Line of Text" & vbCrLf & "Second Line of Text"

Else said:
the field is a Memo data type and i want to insert several lines of text
which will then be merged to a Word document
Click to expand...
Click to expand...
 
I assumed you were trying to create your memo field programmatically from
hard coded text or other fields on a form. I assume from your question, the
memo field is simply in datasheet view of your table ?
Create a form using the form wizard based on your table and simply type the
text into your memo field using the form. You can add your carriage returns
as normal as if you were typing into a text document.

If I have still not understood properly what you are trying to do then
please give a more detailed decription.

Else said:
Hi Dennis,

I am afaraid i dont understand your short hand fully. Could you expand a bit
please.

Thanks Else

Dennis said:
[MemoFieldName] = "First Line of Text" & vbCrLf & "Second Line of Text"

Else said:
the field is a Memo data type and i want to insert several lines of text
which will then be merged to a Word document
Click to expand...
Click to expand...
Click to expand...
 
the field is a Memo data type and i want to insert several lines of text
which will then be merged to a Word document
Click to expand...

Either type Ctrl-Enter, or - if you're using a Form to insert data, as
you should be - change the textbox's Enter Key Behavior property to
"new line in field".

John W. Vinson[MVP]
 
Else: Open the Properties of the Memo Field (in Design View) and change the
"Enter Key Behavior" from Default to New Line in Field. This will allow you
to use a carriage return in a Memo Field. I hope this helps!!
 
Back
Top