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.
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.
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]
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
