[b]ControlTip Text in Switchboard (Can they be changed)[/b]

[8177]

Hi Guys

Does anybody know if you can change the ControlTip Texts within the switchboards depending on which switchboard you are looking at

If so how?

 

[CautionMP]

Yes. Building on the structure that Access gives you when you create a Switchboard you could add a field to the table [tt]Switchboard Items[/tt] called [tt]ControlTip[/tt]. Then in the form module make the following changes to [tt]FillOptions()[/tt]:

Private Sub FillOptions()
...
  ' If there are no options for this Switchboard Page,
  ' display a message.  Otherwise, fill the page with the items.
  If (rs.EOF) Then
      Me![OptionLabel1].Caption = "There are no items for this switchboard page"
  Else
      While (Not (rs.EOF))
          Me("Option" & rs![ItemNumber]).Visible = True
          [b]Me("Option" & rs![ItemNumber]).ControlTipText = rs![[i]ControlTip[/i]][/b]
          Me("OptionLabel" & rs![ItemNumber]).Visible = True
          Me("OptionLabel" & rs![ItemNumber]).Caption = rs![ItemText]
          rs.MoveNext
      Wend
  End If
...
End Sub

Hope this helps,
CMP


(GMT-07:00) Mountain Time (US & Canada)

 

[8177]

Thanks for this its a great help

Malc