Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / November 2004

Tip: Looking for answers? Try searching our database.

Using VBA to make a field numeric

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SandyF - 15 Nov 2004 16:11 GMT
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 - 15 Nov 2004 20:43 GMT
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/

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.