|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
List Box??
I am very new to access and have no knowledge about database/programming.
This is my first day working on Access.I am in the process of creating a table.One datafield which is called "Volunteer interest type" needs a list box from which the user can select values like "planting trees" or "Giving blood".Is there a way of creating a Listbox while defining a datafiled in the table.Or is there anyway I can do this? Any help with this is greatly appreciated.Thankyou. . |
|
#2
|
|||
|
|||
|
In a table you won't have the choice of a list box. However you can select the combobox for the items you wish to list using the value type. Then in your form, you can change the combobox to a list box by right clicking on the combobox in design view and select Change To, and then change the combobox to a list box.
lwells |
|
#3
|
|||
|
|||
|
Thankyouvery much for your reply.This is very advanced for my level of knowledge.
How do I select the combobox?I Have created the table in design view and defined the datafield as "VolunteerInterestType".Can you take me from here?Thanks again for your time. |
|
#4
|
|||
|
|||
|
Actually, I was mistaken, you can make a list box while designing your table. After you create your field and set the datatype to Text while in the table design view, at the bottom you will see a tab folder labeled Look Up. After clicking on that tab, place your curser in the text box and that will open a drop down arrow to choose either a text box or a list box or a combo box. Select list box, then in the area that displays Table/Query (Row Source Type) place your curser in that field to open a drop down box. Then select Value List. In the next text box below that (Row Source) you can type in what you want followed by the ; separator... "Planting Trees"; "Giving Blood" etc.
lwells |
|
#5
|
|||
|
|||
|
Thanks a lot.It worked
![]() |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > List Box?? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|