go to a new line.

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

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
 
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.
 
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)


Steve Schapel said:
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
Click to expand...
Click to expand...
 
Back
Top