ignore street number on Combo Box Autoexpand

[efandango]

I have a list of street names in a form's Comb Box, some of the streets have
more than one door number.

I want the user to be able to type the first letter, that for example, is
the letter 'M' for Main Street, and then the Combo Autoselect go to the first
avaliable address beginning with 'M' which in the example below is '53 Main
Street'. Is this possbile?

eg:
South Street
West Street
53 Main Street
21 Main Street
Main Street
East Street
North Street

 

[Minton M]

I have a list of street names in a form's Comb Box, some of the streets have
more than one door number.

I want the user to be able to type the first letter, that for example, is
the letter 'M' for Main Street, and then the Combo Autoselect go to the first
avaliable address beginning with 'M' which in the example below is '53 Main
Street'. Is this possbile?

eg:
South Street
West Street
53 Main Street
21 Main Street
Main Street
East Street
North Street

Not really - one easy solution is have more than one column and drop
the street name into the first column and then the number (or even the
whole address) into the next. This will fix the combo auto-matching.

Another solution, if you're really married to the idea, is to have a
textbox and listbox working together with entries in the textbox
driving the selection in the listbox - then you could achieve this.

Hope this helps,
James

 

[efandango]

I can't seperate the names from numbers for different columns. Yes, I am keen
to have this feature because it means the user can use the keyboard for
Auto-Expand input. I know I can use a seperate coumn to drive the 'No and
text' column. I was raher hoping that there was some clever code to just make
the conversion on-the-fly