Word Wrap Control Tips (Access 2000)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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.

Reply | Quote

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….

Reply | Quote

Well, each of the Office apps has its own development group, Mark. Nobody ever said they actually *talked* to each other.

Reply | Quote

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…

Reply | Quote

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

Reply | Quote