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

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
bull [ Fr, 25 Januar 2008 18:16 ] [ ID #1916249 ]

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

"Bull" <MrsForeman [at] gmail.com> schreef in bericht
news:3dc817b6-1da4-4ba8-8751-48a1f4df0e03 [at] 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
arracomn_o_s_p_a_m [ Fr, 25 Januar 2008 20:36 ] [ ID #1916256 ]
Datenbanken » comp.databases.ms-access » Add or append data to existing data already stored in a text or memo

Vorheriges Thema: Access 2007: Creating a local relationship between two remote ODBC
Nächstes Thema: Hyperlinks and Split Databases