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.
Hi Sandy,
see (1 line)
http://www.google.de/groups?hl=de&lr=&threadm=t5vjc0tbgakech3s1b7gqo9ve5bd5bk96a
%404ax.com&rnum=2&prev=/groups%3Fhl%3Dde%26lr%3D%26scoring%3Dd%26q%3Dnumeric%2Bg
roup%253Amicrosoft.public.word.vba*%2Bauthor%253AHelmut%2Bauthor%253AWeber
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&lr=&threadm=sd52n0tp8vh8joucd255hlhjsjgd9rvnqj
%404ax.com&rnum=2&prev=/groups%3Fhl%3Dde%26lr%3D%26scoring%3Dd%26q%3DJonathan%2B
like%2Bgroup%253Amicrosoft.public.word.vba*%2Bauthor%253AHelmut%2Bauthor%253AWeb
er%26btnG%3DSuche
---
Greetings from Bavaria, Germany
Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word XP, Win 98
http://word.mvps.org/