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 Rhinorhino 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
Joined
Jul 3, 2003
Messages
955
Location
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 Question
Can Access be used to generate and respond to text messages?
Replies
6
Views
6K
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question Question
How to send/receive text/SMS message through Access
Replies
1
Views
478
jedraw
jedraw
qqp
  • Locked
  • Question Question
Need my msgbox that warns user of missing criteria to stop the rest of the code from running
Replies
2
Views
497
Andrzejek
Andrzejek
meagain
  • Locked
  • Question Question
Negative numbers to Bracketed text
Replies
2
Views
334
meagain
meagain
08211987
  • Locked
  • Question Question
Access 2016 Long Text truncation
Replies
2
Views
334
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top