Occasional Combo Box Problem

[Divit11]

Is there a way around this occasional problem with and combo box using a select query in Access 2000?

The query in Row Source is:
SELECT [qryCSZ].[pcID], [qryCSZ].[pcCity], [qryCSZ].[pcStProv], [qryCSZ].[pcZip] FROM qryCSZ ORDER BY [qryCSZ].[pcCity], [qryCSZ].[pcStProv], [qryCSZ].[pcZip];

The problem occurs when I enter a pcID number and Access will display the first string of numbers that begin with the entered number that comes up in the select list .

Example: pcID City StProv Zip
53 Addison IL 60101
206 Alsip IL 60603
5 Anywhere IL 60nnn

Using this example, if I want to choose Anywhere and enter the value 5 into the combo box, Access finds the first occurrence of 5….. and puts 53 into the box. If the user is not paying attention they get Addison instead of Anywhere.

Its almost like Microsoft Word finishing a word for you.

Any work arounds would be greatly appreciated.

 

[RuralGuy]

I would think you would hide the pcID column and bind the ComboBox column to column 1.

 

[Divit11]

Thanks for the response RG. I only want the pcID value to be stored and written to a related table when the form is saved.

But, your response did cause me to look at the help for the BoundColumn Property and at the very bottom of the remarks portion was the reference to the AutoExpand Property. I had it set to yes and my problem disappeared when I reset it to no.

Thanks for the added focus.

 

[RuralGuy]

Glad to be of assistance.