Combo/List boxes

[Guest]

Hi,
I know this is probably going to have a simple solution but I just can't
figure it out at the moment. I want my combo boxes, when in a form, to show
the drop down list ie you click on the downward arrow and it displays a list,
you click to choose. Instead it keeps making them the kind of list where
there are up AND down arrows and as you click them, different values appear
in the window. I don't like this, I prefer the drop down list to actually
appear in full and then let me click my choice. Does anyone know how to
change it from the scroll list thing into the drop down-and-select thing? It
does it for some of my lists but not all.

Thanks in advance
Ian

 

[Brendan Reynolds]

I think what you want is the List Rows property of the combo box. You'll
find it on the Format tab of the Properties window in form design view. It
defaults to eight rows, meaning the drop down list will be sized to display
eight rows at a time. If there are more than eight rows in the list, then
you'll see the scroll bar.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Guest]

Thanks have changed the properties in the table to begin with - didn't
realise I then had to delete the labels from my form and add them again for
my changes to take effect. Have resolved this now thanks for the help !