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).

laralea wrote:
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

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

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
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Jay Freedman" wrote in message
...
laralea wrote:
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

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

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.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

Suzanne S. Barnhill wrote:
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.


"Jay Freedman" wrote in message
...
laralea wrote:
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

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org