Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Word Wrap Control Tips (Access 2000)

    Is there a switch somewhere that regulates these? I've recently started to use them but instead of wrapping neatly as in the Microsoft-rolled ones, mine just appear as a long line of text that carries on beyond the edge of the screen.

    David Parton

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Word Wrap Control Tips (Access 2000)

    Have you tried embedding CR/LF characters in the text string? It seems to me that used to work, though I haven't tried it in a loooong time.
    Wendell

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Word Wrap Control Tips (Access 2000)

    I have just tried this, and found that if I type Shift Enter into the control tip in the properties box it spreads the tip over two lines.
    Regards
    John



  4. #4
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Word Wrap Control Tips (Access 2000)

    That's interesting, I've always used CTRL+ENTER to enter "hard returns" in ControlTip Text property - didn't know that SHIFT + ENTER works too. But note that SHIFT + ENTER works in the Property Sheet but NOT in the Zoom window, while CTRL + ENTER works in both. If setting property in code then you can use vbCrLf for hard return. And remember, when entering text in an Excel cell or the formula bar you enter ALT+ENTER for a hard return.... nothing like consistency....

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Word Wrap Control Tips (Access 2000)

    Well, each of the Office apps has its own development group, Mark. Nobody ever said they actually *talked* to each other. <img src=/S/nuts.gif border=0 alt=nuts width=15 height=15>
    Charlotte

  6. #6
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Richland, Washington, USA
    Posts
    407
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word Wrap Control Tips (Access 2000)

    Okay, so now that we're on the subject of consistency... Anyone know how to introduce a hard return into the "Screen Tip" text when customizing a Office Toolbar control? Various combinations of Ctrl, Alt, and Shift don't seem to work. Also, this field does not have a Zoom pop-up (presumably because it's an Office-not-Access feature). Probably could do it through VBA code, but that's a bit of a hassle for what should be such a simple thing...

  7. #7
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Word Wrap Control Tips (Access 2000)

    I could not find ANY way to do this via user interface using "Customize" then opening Properties dialog for selected toolbar control - that would be way too simple, I guess. But not hard to do using VBA. Example:

    Public Sub SetCommandbarTooltipText(strCmdBar As String, strCtl As String, strToolTipText As String)

    Dim cmdbar As Office.CommandBar
    Dim ctl As Office.CommandBarControl

    Set cmdbar = CommandBars(strCmdBar)
    Set ctl = cmdbar.Controls(strCtl)

    ctl.TooltipText = strToolTipText

    Set cmdbar = Nothing
    Set ctl = Nothing

    End Sub

    Example of use:

    SetCommandbarTooltipText "Database","Link","Line1" & vbCrLf & "Line2"

    This will set ToolTip for a custom button named "Link" on Access Database toolbar to:

    Line1
    Line2

    See attd screenshot for illustration of this. Note you have to set reference to applicable version of Office - in my example, using Office XP, reference set to MS Office 10.0 Object Library; though this should work in earlier versions of Access/Office (97 or later) AFAIK.

    PS: Note that if you set TooltipText property using above method, it "sticks" - meaning if you close Access & reopen, the 2 line ToolTip will appear as entered via code. BUT: If you then open Customize dialog & view the button's Properties, only "Line 1" will appear, and when you close Customize dialog, the ToolTip will display first line only....

    HTH
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •