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
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".
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!!
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
