Using setvalue to insert text into a memo field

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

Guest

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
 
Use this as the expression for the SetValue action:

[NameOfMemoField] & Chr(13) & Chr(10) & "Your new text string"
 
Hi Ken,
tried it, made no difference?
The inserted text is from a text field on the form.

Nick

Ken Snell said:
Use this as the expression for the SetValue action:

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

--

Ken Snell
<MS ACCESS MVP>

Nick DeaneUK said:
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
Click to expand...
Click to expand...
 
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>

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

Nick

Ken Snell said:
Use this as the expression for the SetValue action:

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

--

Ken Snell
<MS ACCESS MVP>

Nick DeaneUK said:
I can insert text in a memo field using the setvalue in a macro. I
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
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

Ken Snell said:
Use this as the expression for the SetValue action:

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

--

Ken Snell
<MS ACCESS MVP>

Nick DeaneUK said:
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
Click to expand...
Click to expand...
 
Back
Top