By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
463,166 Members | 790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 463,166 IT Pros & Developers. It's quick & easy.

Access 2010 - Combo Box - Value not Valid...

Expert 100+
P: 446
It seems Access 2010 is associating an 'input mask' or field type with a combo box when a form is opened, even though there is no Format setting on the control.

I have a form which has been running OK for years in Access 2003; it adds an item selected from an inventory listing to either an existing Sales Order or Purchase Order. For historic reasons Purchase orders are alphanumeric and Sales orders are numeric (long integer). The RowSource is set in the form's OnOpen event. Existing Sales Orders are listed in the combo box OK but when the form was used to select a Purchase order we got an error message "The value you entered is not valid for this field" - " may have entered text in a numeric field..."

On inspection I found that the 'Sales' order query had remained 'hard coded' as the RowSource in the Properties dialogue box. Simply removing this to leave a blank RowSource enabled the form to work 'normally' again.

I feel this is something new to Access 2010 so am writing about it in case other are stuck on it too.

I've hit another problem in my 2003 to 2010 migration which also involves a combo-box (displaying a wrong value). I can't resolve this and will write it as a separate thread after a few more tests.
Jul 8 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,072
Thanks for sharing.

Did you test the bound column and number of columns of the trouble combo ?

Jul 8 '10 #2

Expert 100+
P: 446
Yes. The combo-box was based on a query returning only two columns (order number and company name). The first column being 'bound', although the form was unbound and used as an intermediate pop-up to select the appropriate order to be opened.
The surprise was that it had been working OK for 10 years but 2010 is processing combos differently.
Jul 8 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.