Format in Message Box
in [Forms]
|
From: Victoria on 2 Apr 2010 19:47 I have a Message Box that is composed like... strMsg = "county : " & cboCounty & vbCrLf & ... etc MsgBox strMsg & vbInformation and looks like... County : Manitoulin Regional Manager : Joe McGuiness Code : A45-X This may be really picky, but I'd like the colons to be lined up vertically just for appearances sake. It doesn't really work using spaces (just like I'm sure it won't in this posting). Is there a way to use tabs when composing the message? Thanks - Victoria
From: Douglas J. Steele on 2 Apr 2010 20:20 It can't be done with the built-in message box. Create your own form with text boxes and use it instead of the built-in message box. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Victoria" <Victoria(a)discussions.microsoft.com> wrote in message news:7EEFD259-9842-4890-BAC7-5DFC53408BD1(a)microsoft.com... >I have a Message Box that is composed like... > > strMsg = "county : " & cboCounty & vbCrLf & ... etc > MsgBox strMsg & vbInformation > > and looks like... > > County : Manitoulin > Regional Manager : Joe McGuiness > Code : A45-X > > This may be really picky, but I'd like the colons to be lined up > vertically > just for appearances sake. It doesn't really work using spaces (just like > I'm sure it won't in this posting). Is there a way to use tabs when > composing the message? Thanks - Victoria >
From: Rick Brandt on 3 Apr 2010 03:41 Victoria wrote: > I have a Message Box that is composed like... > > strMsg = "county : " & cboCounty & vbCrLf & ... etc > MsgBox strMsg & vbInformation > > and looks like... > > County : Manitoulin > Regional Manager : Joe McGuiness > Code : A45-X > > This may be really picky, but I'd like the colons to be lined up > vertically > just for appearances sake. It doesn't really work using spaces (just like > I'm sure it won't in this posting). Is there a way to use tabs when > composing the message? Thanks - Victoria You can use vbTab... "County" & vbTab & vbTab & vbTab & vbCrLf & _ "Regional Manager" & vbTab & vbCrLf & _ "Code" & vbTab & vbTab & vbTab ....but it might not give consistent results across multiple PCs due to font size and DPI settings. (I just guessed on the number of vbTabs to use)
|
Pages: 1 Prev: cant find field Next: Selective use of Spellchecker to ignore forename |