Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding a blank option to a combobox
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00146606
Message ID:
00146702
Views:
22
Michelle,

I put a 0, Unknown item in the codes table. In some cases I disable that line in the cbo so it can't be selected. The cbo class has an mlAddUnknown flag that I can set for cbos that need that feature. If it is set I add that element to the cbo array.

>Frequently, my combo boxes are a list of codes that I use to set a filter. The codes are stored in a table along with their description. So for the recordsource, I use SQL:
>
>SELECT code, desc FROM codetable INTO CURSOR tmp ORDER BY code
>
>This works great if I want to force them to choose a code. But in some cases, I want them to be able to set the filter to everything. So, I want to put in the option to choose "". I don't, however, want to have "" as a code, since the codes are user-editable and they're likely to delete it. (Yeah, I know, I could get around that, but it makes things much more complicated)
>
>Is there an easy way to add the blank choice? I tried setting the SQL, then in the init doing THIS.AddItem(""), but I get an error. I think it was data type mismatch, but this was last night, so I don't remember for sure.
>
>I also tried, in the init, putting the SQL there, then doing AddItem to each record in tmp, and setting the rowsource to 0. I get the same error.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform