Solved

ComboBox, no item can be selected

Posted on 2001-08-04
7
208 Views
Last Modified: 2010-05-02
I fill a ComboBox at runtime before showing it.
The box is empty; clicking the dropdown button shows the items, but no item can be selected.
Even when I set TopIndex to 0, the box remains empty.

What's wrong ? The ComboBox is not data bound.
It was once, but the data control was removed,
and the fields "DataField", "DataFormat", "DataMember" and "DataSource" are all empty.
0
Comment
Question by:PC-Alex
7 Comments
 
LVL 2

Accepted Solution

by:
GregJennings earned 100 total points
ID: 6352202
I'm sure you've checked this, but...have you checked the Locked property?
0
 
LVL 16

Expert Comment

by:Richie_Simonetti
ID: 6352270
Using .text property from combo control could helps.
0
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 6352319
As GregJennings sugests, you will get that effect if the ComboBox .LOCKED property is set to True.
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 17

Expert Comment

by:smozgur
ID: 6352487
please try setting combobox.listindex=0 runtime.

suat
0
 
LVL 1

Author Comment

by:PC-Alex
ID: 6352849
Thank you all! It was the Locked property, and Greg was the first one to give the hint, so he gets the points.

I had interpreted "Locked" as a property that prevents a user from typing custom text into the combo box control ... now I know this was wrong.
0
 
LVL 17

Expert Comment

by:smozgur
ID: 6352885
It is also possible but not by Locked Property; (You may already know this)

DropDown Combo Style prevents a user from typing custom text.

regards
suat
0
 
LVL 1

Author Comment

by:PC-Alex
ID: 6352905
Right, stuat, thanks for the hint.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now