Re: Form Builder puzzle

John,

[Quoted] [Quoted] A check constraint at the database level will cause increased traffic as the [Quoted] [Quoted] database must inform the application that the insert or update operation has [Quoted] failed. As well you will have to code in exceptions to handle it to tell the user why the operation has failed.

[Quoted] [Quoted] A number mask is probably getting close to the solution but as I have found [Quoted] out from experience only forces the user to use more zeros!. Of course, [Quoted] [Quoted] there is no way I am aware of, to ensure that the telephone number is valid but the things I check for are:
[Quoted] [Quoted] - Are all the digits the same? If so reject it, [Quoted] - Are the first three or the last four digits identical? If so, ask the user for verification!

HTH. Brian

[Quoted] "John N" <jn14624_at_yahoo.com> wrote in message news:87mmb5$b9l$1_at_bob.news.rcn.net...
> Have a telephone # col in my form that was being skipped or 0's entered
into
> by users. I want to avoid that.
> My solution can be (is this the best way?):
> 1. Set up a check constraint on the col
> 2. Set up a number mask on the Property for the col
>
> Anyone?
> Thanks,
> John N
>
>
Received on Mon Feb 07 2000 - 16:07:42 CET