"Flagging" fields if they are incorrect (validation)

[ecorg911]

Hello, I am currently trying to implement a validation rule to a specific field, although I can enter validation rules and they work correctly.

Though is it possible (and if how so) to "flag" the field if no data is entered or invalid data is entered, and then come back to it later, without the validation rule from stopping you?

Any help would be greatly appreicated.

Thanks

 

[WayneRyan]

eco,

You can obviously use queries/reports to show invalid data.

You can also use Conditional Formatting and highlight them as they are viewed.

hth,
Wayne

 

[ecorg911]

Sorry, I think you misunderstood me.

My wording was poor, what I am trying to accomplish is for the user to enter data and then make Access verifiy with the user if this is the correct data they wanted to enter.

 

[dkinley]

So you have one field on a form. If you set the validation rules, that in itself can be a flag. For instance, the text in the field could be set to the color red so the user would be aware but allowed to continue.

Now, if you want to do some sort of query after some interval, you could quasi-create that validation in a query so that the query only returns an invalid list. This would let the user know which records are not valid - thus a query on 'flagged' fields.

If neither is an option, then you could create another field .. say a checkbox. If the field (or form) fails validation, this checkbox is automatically checked. Then you could run your query against this checkbox or what-have-you. The checkbox would be automated and controlled only through the validation process.

Last option is to use perhaps and If-Then. If field is not valid, then do not allow the user to close the form until the discrepancy is resolved.

Hope that helps,
-dK

 

[ecorg911]

So you have one field on a form. If you set the validation rules, that in itself can be a flag. For instance, the text in the field could be set to the color red so the user would be aware but allowed to continue.

Now, if you want to do some sort of query after some interval, you could quasi-create that validation in a query so that the query only returns an invalid list. This would let the user know which records are not valid - thus a query on 'flagged' fields.

If neither is an option, then you could create another field .. say a checkbox. If the field (or form) fails validation, this checkbox is automatically checked. Then you could run your query against this checkbox or what-have-you. The checkbox would be automated and controlled only through the validation process.

Last option is to use perhaps and If-Then. If field is not valid, then do not allow the user to close the form until the discrepancy is resolved.

Hope that helps,
-dK

Thanks, spot on as usual , I think I will go with the checkbox method, as I can implement this with ease.

Thanks again!

 

[dkinley]

No problem. Good luck!

-dK