Re: Validation Rule for field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Klatuu,

Klatuu wrote:

I don't think it allows the control you need, for starters,

Yes it does. It provides precisely and simply the exact control you need if you have a field-level or table-level validation requirement.

and most important, should you ever have to upsize, it creates a problem. Not all database engines will recognize it.

Well, this applies to a lot of data types, properties, etc... Do you avoid them all for the same reason? Thereby denying yourself some of Access's most attractive bebefits. I can't believe anyone would consider this a valid design choice.

Also, if you are modifying or debugging it is not readily obvious.

Yes it is. It wouldn't be obvious to you, maybe, because you don't use it so therefore don't think of it.

I just think it is better to do all validation using VBA in the form.

No it's not. Certainly there are pleanty of scenarios where form-level validation is applicable... but not in the examples we have been discussing.

If it works for you and you like it, okay. I would not use it 

Fair enough.

and I advise that it not be used. 

In my opinion, you are doing a disservice to those you so advise.


--
Steve Schapel, Microsoft Access MVP
.

Relevant Pages

  • Re: Evaluating validationrule
    ... There is not much reason not to know what the VR is for a field you ... > the user from seeing any database engine error messages. ... are no validation errors. ... Create an unbound control on the form ...
    (microsoft.public.access.modulesdaovba)
  • Re: data validadtion
    ... I have used your suggested DLookup, ... The reason for the 3 forms is that it has simply proved useful to allow ... Food for thought though - and I've now got the validation that I wanted, ... > it is just a combo box lookup with limit to list. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Customize the client side validation in asp.net
    ... conflicts with the client side validation script from asp.net, ... Another reason is that I have heard many times that asp.net ... If you want to use a framework to expediate your ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Critique my LINQ to SQL strategy using stored procs, please
    ... The reason I ... considered LINQ in the first place was for the ease of access to the ... stored procs and parameters via the auto-generated methods. ... the validation, simple validation ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Page.Validate
    ... Here is a good reason to call ... I believe you can use the IsValid property of the validator itself to ... > prevent the page from posting in the first place then the server validate ... > validation didn't catch anything. ...
    (microsoft.public.dotnet.framework.aspnet)