Very Computer

by **Bob Rupl** » Mon, 07 Apr 1997 05:00:00

> I have a simple problem. I have a database CUSTOMERS with field name
> nPhone, which is a numeric of field 10. I want the field to display
> in a grid in the usual phone # style, i.e. "(999) 999-9999". I have changed
> the Inputmask property to (999) 999-9999 which gives me the desired effect
> ONLY when the phone # field has focus. When the focus moves off it,
> the field loses its punctuation, i.e. reverts to 9999999999 format.

> I want the field to always format to (999) 999-9999 regardless if it
> has focus or not. I have played with the format property without success.

--
Bob Ruple
http://www.ix.netcom.com/~bruple

by **Nick Kravi** » Tue, 08 Apr 1997 04:00:00

Fox Gurus -

I have a simple problem. I have a database CUSTOMERS with field name
nPhone, which is a numeric of field 10. I want the field to display
in a grid in the usual phone # style, i.e. "(999) 999-9999". I have changed
the Inputmask property to (999) 999-9999 which gives me the desired effect
ONLY when the phone # field has focus. When the focus moves off it,
the field loses its punctuation, i.e. reverts to 9999999999 format.

I want the field to always format to (999) 999-9999 regardless if it
has focus or not. I have played with the format property without success.

Help or helpful prodding greatly appreciated.

Nick Kravitz

*****************************************************************
*while (!Dead(Self,++Age)) { Nick Kravitz *

* SleepReceived--; } http://www.mnsinc.com/sniper/ *
*****************************************************************

by **Frank Smit** » Tue, 08 Apr 1997 04:00:00

try (###) ###-#### and see what haps
--

> Fox Gurus -

> I have a simple problem. I have a database CUSTOMERS with field
name
> nPhone, which is a numeric of field 10. I want the field to display
> in a grid in the usual phone # style, i.e. "(999) 999-9999". I have
changed
> the Inputmask property to (999) 999-9999 which gives me the desired
effect
> ONLY when the phone # field has focus. When the focus moves off it,
> the field loses its punctuation, i.e. reverts to 9999999999 format.

> I want the field to always format to (999) 999-9999 regardless if
it
> has focus or not. I have played with the format property without
success.

> Help or helpful prodding greatly appreciated.

> Nick Kravitz

> *****************************************************************
> *while (!Dead(Self,++Age)) { Nick Kravitz *

> * SleepReceived--; } http://www.mnsinc.com/sniper/ *
> *****************************************************************

by **ga..** » Wed, 09 Apr 1997 04:00:00

Quote:>I want the field to always format to (999) 999-9999 regardless if it
>has focus or not. I have played with the format property without success.

Set the Sparse property of the Column to .F. this will solve your
problem.

Gabor

by **Mr. L. E. Pha** » Wed, 16 Apr 1997 04:00:00

Quote:>Fox Gurus -

>I have a simple problem. I have a database CUSTOMERS with field name
>nPhone, which is a numeric of field 10. I want the field to display

nPhone should be a character base and not numeric. Unless of course you
plan on doing number crunching with the phone numbers... :)

Hope this helps,
Louis

http://www.apci.net/~mrlmz
[Christian T-Shirts]

Very Computer

Phone # Mask

Phone # Mask

Phone # Mask

Phone # Mask

Phone # Mask

Phone # Mask