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

Paste to ComboBox: NotInList

P: n/a
Hi,

Access 2002: We've got a DataSheet-Form with a Combobox-field that
shows strange behaviour.

The ComboBox is constrained to the list so if we paste a value not
existing in the list we get a Not-in-list-error. But sometimes we also
get this error when pasting items which are part of the list.
Sometimes, not allways. It is not comprehensible for me what's
different for the strings where it works.

Any hint is greatly appreciated.

Thanks,
Stephan

May 18 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
steph wrote:
Hi,

Access 2002: We've got a DataSheet-Form with a Combobox-field that
shows strange behaviour.

The ComboBox is constrained to the list so if we paste a value not
existing in the list we get a Not-in-list-error. But sometimes we also
get this error when pasting items which are part of the list.
Sometimes, not allways. It is not comprehensible for me what's
different for the strings where it works.

Any hint is greatly appreciated.


Two things come to mind...

1) Your paste might include non-visible characters that cause the not-in-list
event to fire.

2) Office AutoCorrect will sometimes change the entry on you in a subtle enough
way as to not be obvious. Look carefully when you try to leave the Combo to
make sure the text isn't changing to something else.

If you find 2) is the problem you can turn AutoCorrect off for that control in
form design.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
May 18 '06 #2

P: n/a
thanks for the hint. but unforunatley it seems i can rule both these
possibilities out.

May 18 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.