CUSTOM MESSAGE BOX

[Guest]

H
I had custom message box in access 97 that displayed a message in three line formate. For which I was ussing @ sine to divide eachline whgere I wanted
Now after updating to 2000 The message in the messagebox comes as one line with @ showing as a part of text. What should I replace the @ sign to get the box working like befor

 

[Jim/Chris]

Try
&vbCrLf

Jim

-----Original Message-----
HI
I had custom message box in access 97 that displayed a

message in three line formate. For which I was ussing @
sine to divide eachline whgere I wanted.

Now after updating to 2000 The message in the messagebox

comes as one line with @ showing as a part of text. What
should I replace the @ sign to get the box working like befor.

 

[Albert D. Kallal]

The msgbox in a2000 and later is the actual VB6 msgbox due to ms-access now
using the VB6 programming language.

That being the case, you have two options:

1) simply put linefeeds in your text (you don't get bold text). So you can
go:

msgbox "this is line one of the text" & vbcrlf & _
"this is line two of the text" & vbcrlf & _
"this is line three of the text"

2) You can trick the system into use the "old" msgobx by using eval, but you
can't use the constants like vbExclimaton etc. (you have to actually use the
"number" in place of vbExcliamtion . So, you can use:

eval("msgbox('test@test2@test3')")

in the debug window...

? vbexclamation
48

So....
eval("msgbox('test@test2@test3,48')")


The above will show each on a separate line. Since for the future we are
using the vb msgbox...then I would use the first solutions..but you don't
get bold.

 

[nassim hamana]

fake you

HI
I had custom message box in access 97 that displayed a message in three

line formate. For which I was ussing @ sine to divide eachline whgere I
wanted.

Now after updating to 2000 The message in the messagebox comes as one line

with @ showing as a part of text. What should I replace the @ sign to get
the box working like befor.