Carriage Return in an Update Query

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

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
 
Fantastic Karl - Much appreciated
--
Sue Compelling


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


Sue Compelling said:
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
Click to expand...
Click to expand...
 
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.
Click to expand...

use the vbCrLf VBA constant:

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


John W. Vinson[MVP]
 
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.

John Vinson said:
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.
Click to expand...

use the vbCrLf VBA constant:

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


John W. Vinson[MVP]
Click to expand...
 
Back
Top