Using setvalue to insert text into a memo field

[Nick DeaneUK]

I can insert text in a memo field using the setvalue in a macro. I have set
the macro to add text to the contents of the memo field, which works ok,
however, I want the next text entered or inserted to start on the next line
instead of being a continues string.

I have wasted 4 hours so far on what seems a such small thing, can anyone
help?

Nick

 

[Ken Snell [MVP]]

Use this as the expression for the SetValue action:

[NameOfMemoField] & Chr(13) & Chr(10) & "Your new text string"

 

[Nick DeaneUK]

Hi Ken,
tried it, made no difference?
The inserted text is from a text field on the form.

Nick

Use this as the expression for the SetValue action:

[NameOfMemoField] & Chr(13) & Chr(10) & "Your new text string"

--

Ken Snell
<MS ACCESS MVP>

I can insert text in a memo field using the setvalue in a macro. I have set
the macro to add text to the contents of the memo field, which works ok,
however, I want the next text entered or inserted to start on the next line
instead of being a continues string.

I have wasted 4 hours so far on what seems a such small thing, can anyone
help?

Nick

 

[Ken Snell [MVP]]

Post the details of the SetValue macro that you're trying to use. Is the
textbox field bound to that memo field that is to get the new string?

--

Ken Snell
<MS ACCESS MVP>

Hi Ken,
tried it, made no difference?
The inserted text is from a text field on the form.

Nick

Use this as the expression for the SetValue action:

[NameOfMemoField] & Chr(13) & Chr(10) & "Your new text string"

--

Ken Snell
<MS ACCESS MVP>

I can insert text in a memo field using the setvalue in a macro. I

have
set

the macro to add text to the contents of the memo field, which works ok,
however, I want the next text entered or inserted to start on the next line
instead of being a continues string.

I have wasted 4 hours so far on what seems a such small thing, can anyone
help?

Nick

 

[Nick DeaneUK]

Sorry Ken,
You were right, I was testing the wrong field!
I had 100 fields to pick from and forgot it started from 0

Thanks for your help.

Nick

Use this as the expression for the SetValue action:

[NameOfMemoField] & Chr(13) & Chr(10) & "Your new text string"

--

Ken Snell
<MS ACCESS MVP>

I can insert text in a memo field using the setvalue in a macro. I have set
the macro to add text to the contents of the memo field, which works ok,
however, I want the next text entered or inserted to start on the next line
instead of being a continues string.

I have wasted 4 hours so far on what seems a such small thing, can anyone
help?

Nick