Msgbox prompt and tabbing
 

I have a need to present neatly lined up columnar data in the prompt of a
message box. (I am just beginning to learn about forms)

the Tab function documentation seems to work only for print files.

I suppose I can examine the data and put in some & space(varname)
'spacers' but that's a fair amount of work and will only get pretty close.

Can anyone describe another way?

thanks.

--
Neal Z

Msgbox prompt and tabbing
 

You want to look into these constants which will allow you to format the
message box to have a columnar appearance

vbTab and vbCrLf (Carriage return line feed)

Try this to see what I mean

MsgBox "This" & vbTab & "That" & vbCrLf & "Mine" & vbTab & "Yours"

--
HTH...

Jim Thomlinson


"Neal Zimm" wrote:

I have a need to present neatly lined up columnar data in the prompt of a
message box. (I am just beginning to learn about forms)

the Tab function documentation seems to work only for print files.

I suppose I can examine the data and put in some & space(varname)
'spacers' but that's a fair amount of work and will only get pretty close.

Can anyone describe another way?

thanks.

--
Neal Z

Msgbox prompt and tabbing
 

Jim -
Works like a charm. Thanks.
It's always so simple when you "know".
Neal


"Jim Thomlinson" wrote:

You want to look into these constants which will allow you to format the
message box to have a columnar appearance

vbTab and vbCrLf (Carriage return line feed)

Try this to see what I mean

MsgBox "This" & vbTab & "That" & vbCrLf & "Mine" & vbTab & "Yours"

--
HTH...

Jim Thomlinson


"Neal Zimm" wrote:

I have a need to present neatly lined up columnar data in the prompt of a
message box. (I am just beginning to learn about forms)

the Tab function documentation seems to work only for print files.

I suppose I can examine the data and put in some & space(varname)
'spacers' but that's a fair amount of work and will only get pretty close.

Can anyone describe another way?

thanks.

--
Neal Z