In that case, you *MAY* want to look into finding or
writing a function that takes a long file path and
"munges" it down to a pre-defined (by you) limited
length and replaces the "replaced portion" with a set
of ellipses (you know - "...").

If you pass the file name to that (just before) you pass
it to the MsgBox you'll get back a value that will
*always* fit. It looks a little odd (MS does/did it quite
a lot) but it makes displays cleaner. You get something
like:
C:\Windows\...\Quid\dev\xy3245\ddl9732.dll
C:\Windows\system32\...\xy3245\ddl9732.dll
C:\Windows\system32\hokem\...\ddl9732.dll

If you set the "length" quite short you could get something
like:
C:\Windows\...\ddl9732.dll
but that may defeat the entire purpose of what you're
trying to do.

I can't remember what they call this technique other than
"munging" although there are other (probably better)
names. I wrote one my self once - no don't ask it was
proprietary and I can't distribute it, sorry - so it's not
that hard to do, just a matter of making sure you get
everything handled in the right order.

Good luck Andi.

David

"Andibevan" wrote in message
...
Thanks David,

I am in agreement with you - ideally I would prefer to use message boxes
as
the information I am trying to display is very simple (the location of a
file), the problem is that the on small laptops (like mine) the screen
margins cause a wordwrap effect for MSGBOX's (forgive me if my terminology
is incorrect but you get the idea). As a result I will probably end up
resorting to building a dynamic userform of some sort - like you say I
feel
like I am going to end up re-inventing the wheel.

Andi


"David F. Schrader" wrote in message
...
Remember that providing messages to the user is an
art which must be handled carefully. Everything must
go through one of the "media" sensory systems you
have available. Right now you are targeting visual
messaging.

If you must present a great deal of information then
creating your own "form" and displaying it is probably
the best way to go. If you have only a limited amount
to display using the built-in "MsgBox" capability is
easier than re-inventing Rome.

If you are really "big" into using the "Msgbox" you
can use a lot of the "built-in" Microsoft "goodies"
to make the "window" look pretty. For example:
you can use the "vbTab" and the "vbCrLf" to add
both vertical and horizontal spacing.

Yes, the size *is* controlled by the size of the user's
screen so you really need to plan for the screen of
user with *smallest* monitor not the largest. The
best thing is to remember the KISS principle when
using MsgBox - "Keep It Simple (Stupid)", That
way the message shouldn't over-flow the screen
display.

David

"Andibevan" wrote in
message
...
Thanks Tom - I will have a play around with your suggestion and see
how
far
I get.

"Tom Ogilvy" wrote in message
...
Generally, you insert a userform and put a label on it. Make it
as
wide
as you need. then you show the form

userform1.show

in the initialize event you could do

Private sub Userform_Initialize()
label1.caption = _
"Copy Information from:- C:\Documents and Settings\abevan\My" & _
"Documents\SM Partition\Drive_H\WIP\WIP - Weekly Checkin\Start"
End sub

back to the message box, you could try:

Sub showmsg()
sStr = "Copy Information from:"
sStr1 = "C:\Documents and Settings\abevan\My" & _
"Documents\SM Partition\Drive_H\WIP\WIP - Weekly Checkin\Start"
MsgBox sStr & vbNewLine & sStr1

End Sub

That might work for you



--
Regards,
Tom Ogilvy

"Andibevan" wrote in
message
...
Tom,

You may well be right - I seem to remember that you can generate a
line
of
code to generate a userform - am I correct or imagining things?

Ta

Andy

"Tom Ogilvy" wrote in message
...
I believe it can be resized using the windows API, but code I
have
seen
to
customize a message box is voluminous - easier to use a userform
I
would
think.

--
Regards,
Tom Ogilvy


"Andibevan" wrote
in
message
...
Hi All,

I am trying to display a large amount of information to the
user
within
a
message box but can't work out how to specify the width of the
box.

As the width of the box is too small, my text word wraps
whereas
I
want
each
piece of information to be contained on a seperate line.

Is it possible to set the size of a message box or do I need
to
use
a
useform.

Would really appreciate it if someone could give me a pointer.

Thanks

Andy