Add or append data to existing data already stored in a text or memo

Add or append data to existing data already stored in a text or memo

am 25.01.2008 18:16:40 von bull

Hi,

Is there a way (besides Case or IIf), to type a value into field1 and
have that value added to the value inside a memo or text field?

Example:
memo/text field has: hello

in field1 i would enter: world (then run a afterupdate event)

the memo/text field, instead of overwriting hello, puts hello world...

Thanks.
Bull

Re: Add or append data to existing data already stored in a text or memo field

am 25.01.2008 20:36:28 von arracomn_o_s_p_a_m

"Bull" schreef in bericht
news:3dc817b6-1da4-4ba8-8751-48a1f4df0e03@y5g2000hsf.googleg roups.com...
> Hi,
>
> Is there a way (besides Case or IIf), to type a value into field1 and
> have that value added to the value inside a memo or text field?
>
> Example:
> memo/text field has: hello
>
> in field1 i would enter: world (then run a afterupdate event)
>
> the memo/text field, instead of overwriting hello, puts hello world...
>
> Thanks.
> Bull

Put something like the following in the afterupdate event:
Me!Memofield = Me!MemoField & " " & Me!Field1

Arno R