Blank line in ComboBox

[TheRealDeal]

I know I have seen where you can enter a blank line in a combobox, but how would I when the source is a Table/Query?

 

[JeremyNYC]

SELECT MyID, MyOtherValue FROM tblYadda

UNION

SELECT 0 AS MyID, "-Select a Value-" AS MyOtherValue, FROM tblYadda

ORDER BY MyOtherValue

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[MinusM]

It is difficult to have a blank line when you are using Table/Query type RowSource. Either you have to add an empty line in the table or paly with the query

To save a null value you can trap events like OnChange with something like

If Combo0.Text = "" Then Combo0 = Null

Best of luck

 

[JeremyNYC]

The blanks lines just make it easier to read. If you click the ... button to the right of that box, you get a qbe grid, so there's no problem there at all.



==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.