Combo Box instructions

[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?

 

[Guest]

Edit the label of the TextBox to read your message - it is done ine the
properties.

 

[Guest]

Actually, I didn't want to use a text box, but have the instruction appear in
the combo box itself

 

[Guest]

Ok. Change the label on the ComboBox to indicate your instructions.

 

[Graham R Seach]

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)

 

[Larry Linson]

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?

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

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.