Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

msgbox - centralise text

Status
Not open for further replies.
scottian

scottian

Programmer
Jul 3, 2003
955
GB
is there a way to have the text central in a message box?

"My God! It's full of stars...
 
Sort by date Sort by votes
As in "centered" ???

You can manually center the text before sending it to the message box
Code: 
    Dim TheMessage                  As String
    Dim PadSpaces                   As Long
    TheMessage = "Test String"
    PadSpaces = (100 - Len(TheMessage)) \ 2
    TheMessage = Space(PadSpaces) & TheMessage & Space(PadSpaces)
    MsgBox TheMessage
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
3K
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
How to send/receive text/SMS message through Access
Replies
1
Views
214
jedraw
jedraw
qqp
  • Locked
  • Question
Need my msgbox that warns user of missing criteria to stop the rest of the code from running
Replies
2
Views
234
Andrzejek
Andrzejek
meagain
  • Locked
  • Question
Negative numbers to Bracketed text 1
Replies
2
Views
123
meagain
meagain
08211987
  • Locked
  • Question
Access 2016 Long Text truncation
Replies
2
Views
100
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top