area codes

[GCC Consulting]

> -----Original Message-----
> From: filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com
>
[mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com]
On
> Behalf Of Jay R. Ashworth
> Sent: Monday, July 14, 2008 4:54 PM
> To: filepro-list at lists.celestial.com
> Subject: Re: area codes
> 
> On Mon, Jul 14, 2008 at 04:51:06PM -0400, Jean-Pierre A. Radley wrote:
> > Robert Pulliam propounded (on Mon, Jul 14, 2008 at 08:15:11AM -0400):
> > | Is there a way to require that the area code always be entered.  West
> > | Virginia is get a second area code and all numbers in the state will
> > | have to be dialed with the area code, ie 10 digits every time.
> >
> > Lop off the second part of the fP-supplied global PHONE edit, so as to
> > not allow the "old" classic format, the one which didn't require an area
> > code.
> 
> Or, better, create a new edit that works that way, and set your columns
> to that.  (Yes, I know some people will say that's not better, it's
> worse.  I disagree with those people.)
> 
> Cheers,
> -- jra
> --
> Jay R. Ashworth                   Baylink
jra at baylink.com

Jay,

This only is easier if one is comfortable with writing or working with
edits.  The other disadvantage of doing this in an edit is you can't put up
a error message specific to this error,  With an edit, the only message will
be "EDIT FAILED".

With catching this in processing either msgbox or errorbox can be used with
information specific to the area code error.  One can even put up the
errorbox and then popup a list box with the 2 area codes and allow the
operator to pick the correct one and then combine the two.

This solution will be faster and easier on the user as the don't have to
return to the field and retype all or part of the phone #.


Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net