Typing single letter into Combobox brings entire field

[Avid Fan]

I am using a combobox to look up a postcode

When I type text into a combobox the first letter brings an entire
suburb into the combobox.

When I backspace over it behaves as I want it to behave. Each letter
brings me closer.

Is there an easy way to fix this?

 

[Gina Whipp]

Avid Fan,

Have a look at...

http://allenbrowne.com/AppFindAsUType.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am using a combobox to look up a postcode

When I type text into a combobox the first letter brings an entire
suburb into the combobox.

When I backspace over it behaves as I want it to behave. Each letter
brings me closer.

Is there an easy way to fix this?

 

[John W. Vinson]

I am using a combobox to look up a postcode

When I type text into a combobox the first letter brings an entire
suburb into the combobox.

When I backspace over it behaves as I want it to behave. Each letter
brings me closer.

Is there an easy way to fix this?

You can set the combo box's AutoExpand property to No... but it's not clear to
me how you want it to behave! This behavior is by design, so the combo will
jump to the first entry in its rowsource which matches the typed entry, to
save having to type it all. Second and third typed characters will continue to
jump to the matching record; e.g. if a table contains rows like

80254
82201
83625
83660

then typing 8 will jump to the first row, typing 83 will jump to 83625, and
typing 836 will jump to the last row. What would you want it to do instead?

 

[Avid Fan]

You can set the combo box's AutoExpand property to No... but it's not clear to
me how you want it to behave! This behavior is by design, so the combo will
jump to the first entry in its rowsource which matches the typed entry, to
save having to type it all. Second and third typed characters will continue to
jump to the matching record; e.g. if a table contains rows like

80254
82201
83625
83660

then typing 8 will jump to the first row, typing 83 will jump to 83625, and
typing 836 will jump to the last row. What would you want it to do instead?

Thats not what happens when I use it. I am using Access 2007 saved as a
Access 2003 database.

Using a combo if using the example above if I type 83 I get

[802543 ]
82201
83625
83660


What happens when you use it.

 

[J_Goddard via AccessMonster.com]

Hi -

As John V. has pointed out, how it behaves depends on the setting for the
AutoExpand property. What is the setting for that property in your combo box?


John

[quoted text clipped - 19 lines]

then typing 8 will jump to the first row, typing 83 will jump to 83625, and
typing 836 will jump to the last row. What would you want it to do instead?

Thats not what happens when I use it. I am using Access 2007 saved as a
Access 2003 database.

Using a combo if using the example above if I type 83 I get

[802543 ]
82201
83625
83660

What happens when you use it.

 

[Avid Fan]

Hi -

As John V. has pointed out, how it behaves depends on the setting for the
AutoExpand property. What is the setting for that property in your combo box?

Ah OK I see. Thanks.