Warning message popup

[kevlar]

Hi all,

I have a table that records water quality parametres. Is there a way in which I can get a popup message to come up telling the user that the data entered is outside the accepted range and corrective measures must be taken?

It would be ideal if the record entry could be highlighted, not the entire row just that specific cell.

Any help would be great

Many thanks

 

[namliam]

You can do it at the data entry point on the form using the Validation option.

You can also try and use conditional formating on a form, to highlight (in red??) any values that our "out of bounds", problem is that you are limited to 3 options.

 

[Cicak]

Yup. Just to add....
You could set a validation rule throught the design view of the table, and set a validation text that appears when the validation rule is violated. E.g. If the validation rule is '> 1000 Or Is Null' it means the entry must be either blank, or more than 1000, and if it is less than 1000 then the validation text will pop-up. (Got that from the MS access help files)

And if you want to do conditional formatting, in the design view of the form select the field you want to apply it to, go to format -> conditional formatting, and set the criteria. For example, you can choose to set a text box's fill colour to yellow if the value in the field is less than 1000.

 

[kevlar]

Thats brilliant thanks