If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update Combo Box
I have seen a commercial application where clicking on a Combo Box
displays a list of current values. At the bottom of this list, there is a dotted line, and below this is displayed "Edit List". The doted line and "Edit List" text are both bold. And of course, clicking on "Edit List" takes me to a place where I can edit the list. I can handle the underlying code, I think, but how is the Combo Box formatted this way (values above, and "Edit List" below), and can someone show me how to do the same thing? It is just perfect for my application. Thanks for the suggestions... |
#2
|
|||
|
|||
Update Combo Box
You cannot do this with the native Access combo box.
-- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "iamnu" wrote in message ... I have seen a commercial application where clicking on a Combo Box displays a list of current values. At the bottom of this list, there is a dotted line, and below this is displayed "Edit List". The doted line and "Edit List" text are both bold. And of course, clicking on "Edit List" takes me to a place where I can edit the list. I can handle the underlying code, I think, but how is the Combo Box formatted this way (values above, and "Edit List" below), and can someone show me how to do the same thing? It is just perfect for my application. Thanks for the suggestions... |
#3
|
|||
|
|||
Update Combo Box
On Feb 10, 7:57*am, "Arvin Meyer [MVP]" wrote:
You cannot do this with the native Access combo box. -- Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com "iamnu" wrote in message ... I have seen a commercial application where clicking on a Combo Box displays a list of current values. At the bottom of this list, there is a dotted line, and below this is displayed "Edit List". The doted line and "Edit List" text are both bold. *And of course, clicking on "Edit List" takes me to a place where I can edit the list. I can handle the underlying code, I think, but how is the Combo Box formatted this way (values above, and "Edit List" below), and can someone show me how to do the same thing? *It is just perfect for my application. Thanks for the suggestions... Alright then. Thanks for responding... |
#4
|
|||
|
|||
Update Combo Box
You can use a UNION query, for example:
select state fromtbl_States UNION select "--------" from tbl_States UNION select "Edit List" from tbl_States "iamnu" wrote: I have seen a commercial application where clicking on a Combo Box displays a list of current values. At the bottom of this list, there is a dotted line, and below this is displayed "Edit List". The doted line and "Edit List" text are both bold. And of course, clicking on "Edit List" takes me to a place where I can edit the list. I can handle the underlying code, I think, but how is the Combo Box formatted this way (values above, and "Edit List" below), and can someone show me how to do the same thing? It is just perfect for my application. Thanks for the suggestions... . |
#5
|
|||
|
|||
Update Combo Box
DrGUI, is there any way to get "Edit List" to show up italicized?
"DrGUI" wrote: You can use a UNION query, for example: select state fromtbl_States UNION select "--------" from tbl_States UNION select "Edit List" from tbl_States "iamnu" wrote: I have seen a commercial application where clicking on a Combo Box displays a list of current values. At the bottom of this list, there is a dotted line, and below this is displayed "Edit List". The doted line and "Edit List" text are both bold. And of course, clicking on "Edit List" takes me to a place where I can edit the list. I can handle the underlying code, I think, but how is the Combo Box formatted this way (values above, and "Edit List" below), and can someone show me how to do the same thing? It is just perfect for my application. Thanks for the suggestions... . |
#6
|
|||
|
|||
Update Combo Box
Unfortunately, No. You cannot format the items in a combobox.
"Balbina" wrote: DrGUI, is there any way to get "Edit List" to show up italicized? "DrGUI" wrote: You can use a UNION query, for example: select state fromtbl_States UNION select "--------" from tbl_States UNION select "Edit List" from tbl_States "iamnu" wrote: I have seen a commercial application where clicking on a Combo Box displays a list of current values. At the bottom of this list, there is a dotted line, and below this is displayed "Edit List". The doted line and "Edit List" text are both bold. And of course, clicking on "Edit List" takes me to a place where I can edit the list. I can handle the underlying code, I think, but how is the Combo Box formatted this way (values above, and "Edit List" below), and can someone show me how to do the same thing? It is just perfect for my application. Thanks for the suggestions... . |
#7
|
|||
|
|||
Update Combo Box
"DrGUI" wrote in message ... You can use a UNION query, for example: select state fromtbl_States UNION select "--------" from tbl_States Clever! -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
Thread Tools | |
Display Modes | |
|
|