Combo box item not in list Runtime 2007

Pekka_Anttila
Pekka_Anttila used Ask the Experts™
on
Problem is only on computers with Access Runtime 2007 version installed, when I use computer with full Access 2007 problem does not exist.
File type .accde and laccdb, both have same problem

The problem relates to unbound combo boxes where the row source is a numeric item queried from a table. Typing a value into the combo will give the message. "The text you entered isn't an item in the list" even though it is. The data item may only be selected by scrolling down the combo list and clicking on it. Normally when you start typing the number, Access predicts the item and whatever you type is in black and predicted part clear.  In this case list behaves just like item is not in the list.
Any other than numeric items does not have this problem.

I have listed in code section the settings of the Combo box


Row Source 	SELECT [Table Work Order1].[Work Order Number], [Table Work Order1].Status, [Table Work Order1].[Job Description] FROM [Table Work Order1];
Row Source Type	Table/Query
Bound Column	1
Limit to List	No
Allow Value List  Edits	Yes
List Items Edit Form	
Inherit Value List	Yes
Show Only Row Source	No
Input Mask	
Default Value	
Validation Rule	
Validation Text	
Enabled	Yes
Locked	No
Auto Expand	Yes
Smart Tags

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014
Commented:
Is this a multi-valued field? If not, try setting the "Allow Value List Edits" to No.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial