go to a new line.

[Rpettis31]

In my macro I have a message that displays
"Customer"&[name]*"has this issue:" &[issue]

I know in many languages \n will move to the next line but that does not work?
How do I get the issue on the next line.


tHanks

 

[Steve Schapel]

Rpettis,

I am surprised that this works at all without spaces in the appropriate
places, and I don't understand the * in there.

Anyway, try it like this:

"Customer " & [name] " has this issue:" & Chr(13) & Chr(10) & [issue]

By the way, as an aside, 'name' is a Reserved Word (i.e. has a special
meaning) in Access, and as such should not be used as the name of a
field or control.

 

[Douglas J. Steele]

Slight typo (an ampersand is missing after [name]):

"Customer " & [name] & " has this issue:" & Chr(13) & Chr(10) & [issue]


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Rpettis,

I am surprised that this works at all without spaces in the appropriate
places, and I don't understand the * in there.

Anyway, try it like this:

"Customer " & [name] " has this issue:" & Chr(13) & Chr(10) & [issue]

By the way, as an aside, 'name' is a Reserved Word (i.e. has a special
meaning) in Access, and as such should not be used as the name of a field
or control.

--
Steve Schapel, Microsoft Access MVP

In my macro I have a message that displays "Customer"&[name]*"has this
issue:" &[issue]

I know in many languages \n will move to the next line but that does not
work?
How do I get the issue on the next line.


tHanks

 

[Steve Schapel]

Oops! Thank you sir.