Protect table cells in Word format from hard returns

G

Guest

Is there a way to prevent someone from entering a return after filling in a
form field?The field and form protection works fine, but users are putting
returns in the cell (not the form field).
 
J

Jay Freedman

laralea said:
Is there a way to prevent someone from entering a return after
filling in a form field?The field and form protection works fine, but
users are putting returns in the cell (not the form field).

There is a way, using several macros, to make the Enter key behave like the
Tab key in a protected form. It's fairly complex.

How to Code the ENTER Key to Move to Next Field in Protected Form
http://support.microsoft.com/?kbid=187985
 
S

Suzanne S. Barnhill

You can accomplish more or less the same thing by just setting an Exact row
height. This won't prevent users from pressing Enter or entering too much
text, but most have sense enough to stop typing when the text starts to
disappear.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
J

Jay Freedman

The method you use has to take into account what will be done with the forms
after they're filled in. If they'll only be printed or saved for future
reference, then the Exact row height is sufficient. If the field contents
will be extracted with a macro, or saved into a database or used for some
other electronic process, the "extra" material will still be in the fields
and could cause problems.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top