Have you seen this command button?

[Me!User]

The attached image shows a command button that operates like a combo-box. When clicked it displays a drop-down menu offering one or more choices.

I found this button in an application that appears to be written in VB and uses an MDB file to store its data (Alloy Software Asset Navigator). It may be written completely in MS-Access VBA but I can't be certain.

I don't know if this button is a stock item in VB or if it is a custom control. Does anyone have information about this button? I want to incorporate it in my forms.

 

[Mile-O]

It looks like a Third Party ActiveX Control. I've never seen it before and it's not in the ActiveX Controls that are immediately installable from Access.

 

[Me!User]

I guess the next question is "Does anyone know who makes this control?"

 

[Me!User]

The same command-combo button is found in MS Outlook 2002. It is part of the Insert File dialog box used to attach files to a message.

Does this imply that it may be in an MS Office DLL? Does that make it accessible to an Access VBA program or is this just wishful thinking?

 

[raskew]

It's relatively simple to combine two controls to
emulate the same functionality and appearance.
You might want to give it a shot:

1) Place a list box on your form.

2) Populate it with the desired options (using a value list).

3) Create the necessary code to perform the options.

4) Set the list's Visible property = No

5) Remove the list's label

6) Create a command button and position it to where the
list's label was.

7) Place this code in the command button's OnClick event:

Me.List1.Visible = Not Me.List1.Visible

This will toggle the list's visibility on/off and will give the
appearance of one control

HTH - Bob

 

[Me!User]

raskew

Say are you my co-worker? He offered the very same suggestion!

Thanks for the idea but a command/combo button has the advantage of being very compact. List boxes require space on a form. A command/combo button uses no more space than a simple command button and can display its drop down menu off the form.