Msgbox... 2 columns?

[hardy1976]

Hi

I want a message box to present data neatly... using spaces to fudge it just isnt working!

As an example I want to present....
Statement A: 40
Date: 10/02/2012
Season: Winter

as

Statement A: 40
--------Date: 10/02/2012
------eason: Winter

I can use spaces (swapped in for the dashes) however the colons are not lining up!!!!

Regards
H.

 

[mdlueck]

Do you mean the MsgBox that is build into VBA?

http://office.microsoft.com/en-us/access-help/msgbox-function-HA001228886.aspx

Or do you mean an Access Form you are developing to display data?

If the latter, perhaps use a mono-space font which has a consistent character width?

 

[hardy1976]

I was thinking vba - however I am unable to find a way of doing it, pop up form a better option?

 

[Kiwiman]

Howzit

Not exactly a scientifc answer, but this looked ok on mine

strMess = "STATEMENT A : 1024 " & vbCrLf & vbCrLf
strMess = strMess & Right("                  DATE :", 20) & " 10/02/2012" & vbCrLf & vbCrLf
strMess = strMess & Right("               SEASON :", 17) & " Winter"

 

MsgBox strMess, vbOKOnly, "Testing..."

 

[boblarson]

Just create your own form, use a listbox formatted to not look like a listbox and go with it.