Carriage Return in an Update Query

[Guest]

Hi -

I am wanting to do 'bulk updates' to a Notes field - based on appropriate
criteria. eg - "I send an email to all Volunteers living in Wellington to
invite them to ....". (NOTE: The user has requested that the Notes field be
one record as opposed to a new record each time a new entry is made)

In my update query I use the following in the 'Update to' - though this just
adds it onto the end of existing text. Is there a way I can insert a
carriage return to have it drop down to the next line.

[Notes] & Now() & " - Sent email invite to Pink Ribbon Gala - Sue"

TIA

 

[Guest]

[Notes] & Chr(13) & Chr(10) & Now() & " - Sent email invite to Pink Ribbon
Gala - Sue"

 

[Guest]

Fantastic Karl - Much appreciated
--
Sue Compelling

[Notes] & Chr(13) & Chr(10) & Now() & " - Sent email invite to Pink Ribbon
Gala - Sue"

Hi -

I am wanting to do 'bulk updates' to a Notes field - based on appropriate
criteria. eg - "I send an email to all Volunteers living in Wellington to
invite them to ....". (NOTE: The user has requested that the Notes field be
one record as opposed to a new record each time a new entry is made)

In my update query I use the following in the 'Update to' - though this just
adds it onto the end of existing text. Is there a way I can insert a
carriage return to have it drop down to the next line.

[Notes] & Now() & " - Sent email invite to Pink Ribbon Gala - Sue"

TIA

 

[John Vinson]

In my update query I use the following in the 'Update to' - though this just
adds it onto the end of existing text. Is there a way I can insert a
carriage return to have it drop down to the next line.

use the vbCrLf VBA constant:

[Notes] & vbCrLf & Now() & " - Sent email invite to Pink Ribbon Gala -
Sue"


John W. Vinson[MVP]

 

[RickD]

Can this also be done within a single text field at a given position or
multiple positions? Ex: I have a line of text that is 200 characters and I
want to insert a return every 10 characters.

In my update query I use the following in the 'Update to' - though this just
adds it onto the end of existing text. Is there a way I can insert a
carriage return to have it drop down to the next line.

use the vbCrLf VBA constant:

[Notes] & vbCrLf & Now() & " - Sent email invite to Pink Ribbon Gala -
Sue"


John W. Vinson[MVP]