Using unbound combo box

[Middlemarch]

It doesn't show item 1 until clicked and then a ghost-like thing appears offering to "Edit List"


Can that be prevented, and item 1 show automatically ?
Thanks.

[June7]

I am not understanding the "ghost-like" thing. Maybe you should provide an image or the db.

[moke123]

that's to bring up the edit dialog for value lists. you can shut it off in the property sheet

[June7]

Ah, that would be the Allow Value List Edits property. Set it to No.

The "ghost-like" thing is either the popup prompt asking if you want to edit list or the list editor - not sure which you meant.

What is Limit To List set for?

[Gicu]

To select first item in row source:

Me.ControlName = Me.ControlName.ItemData(0)

https://www.fmsinc.com/microsoftacce...ect-first.html
Cheers,

[Middlemarch]

Thanks for the replies, slowly getting it doing what I want.
But puzzled by it's click event. It seems to fire only on the dropdown list.
It's set to null to remove any previous value. I was using only

 Do While mycbo.ListCount > 0
    mycbo.RemoveItem (0)
    Loop

But that did not remove any first (single) item. The null does.
Whether there's anything showing or not, can I detect a click without having it dropdown first?

[June7]

Apparently not. GetFocus will trigger.

What are you trying to do? Why do you want to remove items?

[Middlemarch]

I tried got focus, click and Mouse up events. Nothing.
It's an unbound combo box (value/list) and I'd like to get a event working when you click on it (before/without using the dropdown)
Remove items was something else (needed to clear it before assigning new values). That's sorted.

[June7]

Can't have what isn't there.

I still don't know why you want this.

[Middlemarch]

>I still don't know why you want this.

I want to run some code if the user clicks it. But if it can't be done I'll find some other way.

[June7]

But what code? What does this code do? If we know the ultimate goal perhaps we can help find a solution.

[Middlemarch]

Sorry June, understood. I haven't written anything yet, just seeing what might work. It was a textbox and its click event (if it was empty) would access a audio file and fill in some specs about it .
I converted it to a combo because the field it was bound to might contain a csv. The combo box could then split it to separate lines. But I want to keep the original click event working.
Which probably means another control just for that. A click on the empty cbo would have worked nicely as it's only needed if it's empty.
Also thinking about using both controls with just the one needed being visible.

[June7]

Making a textbox and combobox work together has been called a "composite" control and is one way to deal with cascading combobox on continuous form. Seems like it would be suited to your situation as well. Size combobox so its textbox area has no width and position a textbox next to the combobox dropdown. Set combobox TabStop No.

[Middlemarch]

Thanks, I'm just giving that a tryout. Is the idea (when you click the dropdown) its textbox area resizes to the textbox width?

[June7]

Oops, forget that part about sizing the combobox. Sit textbox on top of combobox text area. Set combobox as TabStop No. If combobox was created last, use right click > Position > Bring to Front on textbox.