validation

[hayden]

in the design view of a table on the general tab when i click validation rule so that the expression builder appears.

what do i type in so that presence check occurs and i can get an error message saying enter a value

also how do i apply length check.

hayden

 

[Khalid_Afridi]

Check this for validation rules in access

 

[SOS]

Sorry, not sure what you mean by "presence check." Can you elaborate a bit further? Are you trying to limit entry values of a single field or multiple fields and if multiple how are they related?

 

[hayden]

as is when you create a new record and only enter certain data into the fields and miss some fields out it gives an error message that a value must be entered

 

[SOS]

For those you select each field individually and then set the validation rule to NOT NULL. And then you can also provide the Validation Message which will come up if your user tries to save without filling it in.

However, I prefer to ONLY let users access my tables through forms, and then I use the form's Before Update event to validate the input.

 

[Khalid_Afridi]

see SOS is very claver... I do the same