Custom control (97)

Topic

New Reply

Custom control
How do you use the OBJECT command from the FORM/REPORT DESIGN category of a command bar

Reply | Quote

Replies

This is the same dropdown list that is (by default) the leftmost control on the Formatting (form/report) toolbar. Is is only enabled when you have a form or report open in design view, and then it is filled automatically.

I don’t think you can use this for your own purposes. If you want a combo box on your toolbar, you must create it yourself in code:

Dim ctlCombo As CommandBarComboBox
Set ctlCombo = CommandBars(“MyCommandBar”).Controls.Add(msoControlDropDown)
With ctlCombo
…
End With

Reply | Quote

Darn, thanks Hans.

Reply | Quote