| re: Paste to ComboBox: NotInList
steph wrote:[color=blue]
> 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.[/color]
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
| 
