469,647 Members | 1,770 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,647 developers. It's quick & easy.

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

446 Expert 256MB
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" - "..you 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
2 6407
3,080 Expert 2GB
Thanks for sharing.

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

Jul 8 '10 #2
446 Expert 256MB
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.

Similar topics

4 posts views Thread by William Bradley | last post: by
4 posts views Thread by jenn | last post: by
2 posts views Thread by Scott | last post: by
8 posts views Thread by ddtpmyra | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.