Combo Box Text

[JamesJ]

In a combo box based on a Table/Query how can I display
something like "Plase make a selection" as opposed to the
cbo being blank prior to making a selection?

Thanks,
James

 

[Tom van Stiphout]

On Thu, 24 Dec 2009 06:47:01 -0500, "JamesJ"

If you're doing Table/Query all the data has to come from a query. So
I create a new table (say tblMakeSelection) with one row in it:
-1, "Please make a selection"
and then I use a union query:
select CompanyID, CompanyName from tblCompanies
union
select ID, Description from tblMakeSelection

-Tom.
Microsoft Access MVP

 

[JamesJ]

Works ok.
Had to set the combo box's default value to -1 to get it to display
initially.

Thanks much,
James