By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,237 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

How to add a blank entry in a Query based combobox?

P: n/a
I like to have a blank entry at top of the combobox list, so the user
is able to clear the combobox.
Right now, the form displays a empty entry on load, but after chosen a
value once, it is not possible to select a blank entry again. The only
way is to delete the string manually and press enter.

Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
Krul wrote:
I like to have a blank entry at top of the combobox list, so the user
is able to clear the combobox.
Right now, the form displays a empty entry on load, but after chosen a
value once, it is not possible to select a blank entry again. The only
way is to delete the string manually and press enter.


Me.Combo0 = Null
Nov 13 '05 #2

P: n/a
Krul wrote:
I like to have a blank entry at top of the combobox list, so the user
is able to clear the combobox.
Right now, the form displays a empty entry on load, but after chosen a
value once, it is not possible to select a blank entry again. The only
way is to delete the string manually and press enter.


Me.Combo0 = Null
Nov 13 '05 #3

P: n/a
I guess with this method I will loose my original query based list
too....

I just want to add a blank entry above the query list.

Nov 13 '05 #4

P: n/a
I guess with this method I will loose my original query based list
too....

I just want to add a blank entry above the query list.

Nov 13 '05 #5

P: n/a
Air Script

SELECT '' AS Description FROM tbl2002Transactions
UNION
SELECT DISTINCT tbl2002Transactions.fldDescription AS Description
FROM tbl2002Transactions
ORDER BY Description

Nov 13 '05 #6

P: n/a
Air Script

SELECT '' AS Description FROM tbl2002Transactions
UNION
SELECT DISTINCT tbl2002Transactions.fldDescription AS Description
FROM tbl2002Transactions
ORDER BY Description

Nov 13 '05 #7

P: n/a
Many thanks. This is really a nice sql hack ;)

Nov 13 '05 #8

P: n/a
Many thanks. This is really a nice sql hack ;)

Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.