Combo Box instructions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to make the combo box display the instructions, such as "Choose
a Status" instead of using a test box. How is this done?
 
Actually, I didn't want to use a text box, but have the instruction appear in
the combo box itself
 
Use a UNION query to define what is shown in the combo.

SELECT x, y, 1 As SortOrder FROM Table1
UNION (SELECT 0 As x, "Choose a status" As y, 0 As SortOrder FROM
MSysObjects WHERE [Name] = "Forms")
ORDER BY SortOrder

....but you'll need code in the AfterUpdate event to decide what to do when
the user makes a selection, because they can select "Choose a status".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
(Currently in Japan)
 
I would like to make the combo
box display the instructions, such
as "Choose a Status" instead of
using a test box. How is this done?
Click to expand...

Clarify what you have and what you want to do. "The combo box" and "the
instructions" don't tell us much, nor does "instead of using a test box". It
will surely save everyone some time and energy if you will explain instead
of having us guess.
Ficticiously Yours, Biggles
Click to expand...

Too cute, and may turn off people who would otherwise try to give you a
serious answer. For good suggestions on effective use of newsgroups, see the
FAQ at http://www.mvps.org/access/netiquette.htm.
 
Back
Top