Re: Form Builder puzzle

What if the person doesn't have a phone number? Why would you want to force and entry when in effect a Null value may be correct...

--Wise Guy

John N <jn14624_at_yahoo.com> wrote in message news:87mv0o$ktt$1_at_bob.news.rcn.net...
> Brian,
> You are right. There is no way to force the correct entry.
> Based on your input I feel like correcting the following:
> 1. setup the format mask for the phone in the Property page
> 2. implement a when-validate-item trigger in the col that will prevent
users
> from inputting repeated patterns within the mask.
> Any other idea out there?
> Thanks people
>
> John Nunez
> --
> I breath, ergo I exist ...
> Brian W. Chester <bwchester_at_home.com> wrote in message
> news:2dBn4.3550$a27.117865_at_news1.rdc1.mb.home.com...
> > John,
> >
> > A check constraint at the database level will cause increased traffic as
> the
> > database must inform the application that the insert or update operation
> has
> > failed. As well you will have to code in exceptions to handle it to
tell
> > the user why the operation has failed.
> >
> > A number mask is probably getting close to the solution but as I have
> found
> > out from experience only forces the user to use more zeros!. Of course,
> > there is no way I am aware of, to ensure that the telephone number is
> valid
> > but the things I check for are:
> > - Are all the digits the same? If so reject it,
> > - Are the first three or the last four digits identical? If so, ask the
> > user for verification!
> >
> > HTH.
> >
> > Brian
> >
> >
> > "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 - 18:37:44 CET