Missing drop-down listbox

[MikeB]

I have MS Access XP (I think that is 2002). I also have Access 2007,
but I cannot use it for this project.

My Help talks about Combo Boxes, List Boxes and Drop-down List boxes.
However, in my Toolbox when working with a Form, there are only icons
for a Combo box and a List Box. I checked, it is not omitted in
customization of the Toolbox.


Is there another place that it could be excluded from?

Was it one of those things that the developers thought about and they
just didn't manage to get it into the code in time?

I guess I could use a Combo box and set it so that people cannot add
entries to the list. Is that the way to go or is there another
subtlety that I'm missing?

Thanks

 

[Jeff Boyce]

Mike

I've not run across a 'drop-down listbox' ... that sounds like what a
combobox does.

If you set LimitToList = Yes, folks will only be able to select items from
the combobox.

If you create an event procedure for the NotInList event, you can give them
a way to add new values to the table that underlies your combobox.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dominic Vella]

As far as I was aware, the drop down list box is the list that drops down
when a combo box is opened up.


Dom

 

[MikeB]

As far as I was aware, the drop down list box is the list that drops down
when a combo box is opened up.

Just an FYI for you and Jeff. Here is a screenshot of my Access Help
that describes the way to create the 3 types of boxes.

http://i161.photobucket.com/albums/t214/HollowOak/access/AccessHelpScreenshot.png
I guess that at some point in time MS figured out that there is
substantially no difference between a combobox with certain properties
vs the drop-down listbox.


I'll be using a Combo box.

 

[Jeff Boyce]

Mike

I suspect this refers to the introduction in Access 2007 of a multi-valued
field data type.

While well intentioned, it does seem to cause confusion for users and is not
particularly accessible to developers.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[MikeB]

Mike

I suspect this refers to the introduction in Access 2007 of a multi-valued
field data type.

Hmm.. except that the help was Access XP (2002?).

If I understand Access 2007 Multi-value datatypes correctly, they
merely create a system (or hidden) table with the values in it and
Access does the relations etc. under the covers?

While well intentioned, it does seem to cause confusion for users and is not
particularly accessible to developers.

Not sure I understand the accessibility issue here, it is described
often in the Help. I think it is just one of those things where they
forgot to take it out of the doc (or left it in to confuse
newbies.. ).

 

[Jeff Boyce]

Mike

Developer-types tend to be inveterate tinkers. When Access does something
"under the covers", tinkers get nervous...<G>.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

Hmmm, maybe I should have called us "tinkerers"...

Jeff