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.
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.
I am not understanding the "ghost-like" thing. Maybe you should provide an image or the db.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
that's to bring up the edit dialog for value lists. you can shut it off in the property sheet
If this helped, please click the star * at the bottom left and add to my reputation- Thanks
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?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
To select first item in row source:
https://www.fmsinc.com/microsoftacce...ect-first.htmlCode:Me.ControlName = Me.ControlName.ItemData(0)
Cheers,
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
But that did not remove any first (single) item. The null does.Code:Do While mycbo.ListCount > 0 mycbo.RemoveItem (0) Loop
Whether there's anything showing or not, can I detect a click without having it dropdown first?
Apparently not. GetFocus will trigger.
What are you trying to do? Why do you want to remove items?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
Can't have what isn't there.
I still don't know why you want this.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
>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.
But what code? What does this code do? If we know the ultimate goal perhaps we can help find a solution.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
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.
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.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks, I'm just giving that a tryout. Is the idea (when you click the dropdown) its textbox area resizes to the textbox width?
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.
Last edited by June7; 02-09-2024 at 08:19 PM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.