H
Hisdteach
When I am in the field name in field properties, I want a list box but I
can't remember how to populate the list to choose from.
can't remember how to populate the list to choose from.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
Cheese_whiz
I use the toolbox to draw my listboxes. You may have to go into the design
mode of the form (or whatever) you are working on, and then hit view|toolbox
(or click the button on one of the toolbars up top). It should be open by
default I think but...
Once that's open, you can choose the type of control you want (including a
list box) to draw and then just left-click on your form and drag to draw it.
On the toolbox, at the top left (if the toolbox is floating ) or near the
left end (if it's placed with the toolbars), there's a "control wizards"
button. If you select that (so that it's "active/on") before you choose the
control you want to add, once you drag the control out you'll get a wizard to
easily set up some options for it.
Hope that's helpful,
CW
mode of the form (or whatever) you are working on, and then hit view|toolbox
(or click the button on one of the toolbars up top). It should be open by
default I think but...
Once that's open, you can choose the type of control you want (including a
list box) to draw and then just left-click on your form and drag to draw it.
On the toolbox, at the top left (if the toolbox is floating ) or near the
left end (if it's placed with the toolbars), there's a "control wizards"
button. If you select that (so that it's "active/on") before you choose the
control you want to add, once you drag the control out you'll get a wizard to
easily set up some options for it.
Hope that's helpful,
CW
C
Cheese_whiz
As an alternative, I think you can just list each choice in the "row source"
area of the data tab of the properties window for the list box. Each choice
should be typed within parens (parenthesis) and seperated by semi-colons.
Then you choose the "row source type" (right above) as "value list".
That's if you already have the list box added I think.
CW
area of the data tab of the properties window for the list box. Each choice
should be typed within parens (parenthesis) and seperated by semi-colons.
Then you choose the "row source type" (right above) as "value list".
That's if you already have the list box added I think.
CW
J
John Vinson
When I am in the field name in field properties, I want a list box but I
can't remember how to populate the list to choose from.
Don't confuse data *storage* - fields which have datatypes - with data
*display* (listboxes, combo boxes, etc.).
Most developers strongly discourage the "Lookup Field" misfeature in
Access: see http://www.mvps.org/access/lookupfields.htm for a
critique. I'd suggest simply making the table field a Date/Time field,
if that's the datatype you want; use a Form to enter data into the
table, and if desired, put a Listbox or Combo Box on the form. That
listbox's Row Source can either be a Query listing the dates you want
available for selection, or you can set it to List of Values and type
in the dates you want available (which of course may pose a problem as
time goes on and these dates become obsolete).
John W. Vinson[MVP]