concatenate a return space

[Bergja]

Is it possible to concatenate a return space when adding data to a field in Access? For example I want to use a text box to add data to a memo field in a table. Each time data is added I want to add space between the new data and the next update so the field would look something like this:

18-July-2008: updated data.
"Return Space"
19-July-2008: updated data.

20-July-2008: updated data.

Is this possible?

 

[maxmangion]

add vbcrlf to your concatenate

 

[doco]

Or if you're really adventursome:

...
    "18-July-2008: " & CHR(13) & CHR(10) '    carriage return and line feed
...

 

[Bergja]

Thanks alot!

 

[maxmangion]

you're welcome