Re: Form Builder puzzle

Brian,
[Quoted] 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 [Quoted] 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

> >

> >

>

>