numbers omitted in form field

  • Thread starter Thread starter WrightAM
  • Start date Start date
W

WrightAM

Ive created a form where I've limited the text entry in
cells to numbers as I want telephone numbers to be
written there. The problem is, once the form is
protected the and I try to fill in the form TAB-ing along
the boxes, the '0' starting each telephone number seems
to be getting cut off at the beginning every time.
Can anyone help? Cheers, Anne.
 
G'day "WrightAM" <[email protected]>,

Telephone numbers are strings, ring me on

+61 (2) 95-606-606

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


WrightAM reckoned:
 
okay I'm sorry if I'm being a bit dim but what should I
do? I can't phone out, I was hoping for an online
solution, if possible?
cheers.
 
Hi WrightAM,
Ive created a form where I've limited the text entry in
cells to numbers as I want telephone numbers to be
written there. The problem is, once the form is
protected the and I try to fill in the form TAB-ing along
the boxes, the '0' starting each telephone number seems
to be getting cut off at the beginning every time.
Click to expand...
don't format the form field as a number, but as text.

Word form fields don't offer you really sophisticated tools
for limiting what a user may enter, and how it should be
formatted. If you want to do any data validation or
formatting, you usually need a macro to take care of the
job.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
G'day "WrightAM" <[email protected]>,

LOL - I didn't mean to literally ring me, I was demonstrating what a
legal phone number format can look like.

One simple way is to scan each char in the string and see if it
matches 0-9+- (), if it does, let it pass. Then count the # of #'s and
check its valid. You can get as complex as you like for data
validation with your own macros, usually I find its not worth it for
phone numbers, and just use what the user put it.

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


WrightAM reckoned:
 
cheers, that worked! thanks
-----Original Message-----
Hi WrightAM,

don't format the form field as a number, but as text.

Word form fields don't offer you really sophisticated tools
for limiting what a user may enter, and how it should be
formatted. If you want to do any data validation or
formatting, you usually need a macro to take care of the
job.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun
8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e- mail
:-)

.
Click to expand...
 
oh sorry i was being v dim!! thanks anyway, I was very
confused, I'm not up on computer terms really as you can
see!
 
Back
Top