Dropdown Autoexpand Selection

[Bob Barnes]

It appears NOT to make a difference if "Auto Expand" is set to "Yes" or "No".

I have a Query as the source for a Dropdown. As an example, the Question
numbers must be in this order...

124
152
75
71
7

If I "SelLength" the existing selected Question, & then type "7", it will
select "75".
If I type "71", it will select 71 after the initial "7" selecting "75".

However, backing out the "1" from "71" brings me back to "75", the "first 7"
in the List.

Can I somehow then type in "7" to get Question number "7"???

TIA - Bob

 

[John Vinson]

Can I somehow then type in "7" to get Question number "7"???

It's going to the first match - in the order in which the values
appear in the combo box.

Only by sorting the combo box in numeric order. Try basing it on a
Query with a calculated field

Val([QuestionNo])

and sort ascending on that field.

John W. Vinson[MVP]

 

[Bob Barnes]

John - GOOD idea. I'll try that.

Thank you - Bob

Can I somehow then type in "7" to get Question number "7"???

It's going to the first match - in the order in which the values
appear in the combo box.

Only by sorting the combo box in numeric order. Try basing it on a
Query with a calculated field

Val([QuestionNo])

and sort ascending on that field.

John W. Vinson[MVP]