checking validation rule (control property)

[tsetse]

Hi,

In a form, it is possible to enter a string as textbox control validation rule; and Access checks after typing anything. OK

Is it possible MANUALLY to ask Access checking the validation rule ?

Here is my problem:
I import data from a flat file to an Access table. This data do not respect necessairy certain validation rules I would like to check.
Situation: in a form I have a record before the eyes. Before jumping to the next record, I want Access to check the validation of the current record fields without retyping in VB code (in a 'BeforeUpdate' Event for example) all the validation rules. Is it possible??? Here is my question.

Thanks now for your precious help

jeff

 

[tlbroadbent]

If the form is bound to the table, Access will check the validation rules when you move from the record. If it is not bound, you'll have to code the validation rules or allow Access to validate upon insert or update of a record. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.