Using VBA to make a field numeric

[SandyF]

I am new to VBA. I created a text form field and made it numeric. The field
is for a phone number. If you enter alpha it makes the field numeric 0. Is
there a way in VBA to make you stop at the field and enter numeric values
only.

 

[Helmut Weber]

Hi Sandy,
see (1 line)
http://www.google.de/groups?hl=de&l...blic.word.vba*+author%3AHelmut+author%3AWeber
pretty complicated, though.
The crucial point is, that a telephone number isn't a number at all,
unlike as (US) 1,000,000.78, which is numeric, apart from other ways
of notations of numbers, including hexadecimal etc., which are all
numeric.
A telephone number is a sequence of digits, possibly seperated by what
you define as seperators, like "/" or "-".
See also
http://www.google.de/groups?hl=de&l...ba*+author%3AHelmut+author%3AWeber&btnG=Suche
---
Greetings from Bavaria, Germany
Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word XP, Win 98
http://word.mvps.org/