Paste bug in form validation?

[Matter]

Hi All,

One of my users recently pointed out that while pasting data into a datasheet form, the validation rules built into the combo dropdown (which grabs valid values from a "CODES" table) do not validate the data being pasted (Tested in Access 2007 and 2010 - same result).

Is this some kind of bug? The form, of course, already has "Limit to list" set to yes, and "allow list edits" set to no. Any ideas on how to accomplish this easily? Should it be an "on update" validation check? Thanks in advance,

Cheers, Matt

 

[MarkK]

I can't produce your result in A2007. Pasting data into the control yields the same warnings as when data is typed into the control.

 

[missinglinq]

Assuming that by "validation rules built into the combo dropdown" you mean validation that you're doing in the Combobox BeforeUpdate event, as is the norm for this kind of thing, Mark is correct, pasting should be treated exactly the same, by Access, as typing the data directly in. Typing data in, pasting it in and scanning it in (as with a bar code scanner) all cause the Control's associated events to execute.

I have to say this sounds somewhat unusual! One of the top reasons for using a Combobox for data input is so that only correct data can be entered.

Linq ;0)>

 

[GinaWhipp]

The only way I can see that happening is if the copied the data directly into the table/ Since the validation is on the form, as stated by others, an error will occur. You can create a relationship of the two tables involved which will then create the error if done at the table level.