MS Word Forms

[gkhn]

Hi all,
We have created an application form via ms word and set the size of the rows to exactly 2 cm length.But we have serious problems with large text fields,let me illustrate.
I did set the length of the addressTextField to 200char and also placed it into a table row and defined the length of the row as 2cm(nearly 2 lines).That means length of the row never expands,it is alwasy same.
However our dummy clients tend to fill addresstextfield like this
street name (push enter)
building name number(push enter)
postal code city(push enter)
country

This causes that we cant see the rest of the addresstextfield after very first two lines.addresstextfield overflows to the invisible lines of the row but our clients dont care and keep typing.So is there any way to limit the row number of textfield just like limiting the length of table row.

regards

gkhn

 

[TonyJollans]

There isn't any property that will limit this, and you can't trap it while the user is typing. What you can do is have an Exit macro attached to the form field, which can examine the contents and issue an error message and force them to re-enter correctly.

I must say, however, that limiting a full address to two lines is a bit unusual and restrictive so you should, at least, make the users aware that they have to do this.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[BlueHorizon]

Hi,
I would create a single textfield for each:

street name (TAB)
building name number (TAB)
postal code city (TAB)
country (TAB)

and instruct your users to TAB and not ENTER.

HTH,


Best,
Blue Horizon

 

[judgehopkins]

http://www.pcmag.com/article2/0,2817,2329451,00.asp

There was a solution in a recent PC Magazine which was for a similar problem.

There are two guaranteed rules of success: First, never tell everything you know.

 

[fumei]

Not really. The answer on that link does not address the OP's issue. "Extra" text entered would still disappear.

BlueHorizon, "and instruct your users to TAB and not ENTER."

Yeah...that would be best, but unfortunately this brings in end-user training. And that the users would, in fact, follow the instructions.

We wish.

I do agree with you that separating data elements (street name, postal code etc.) is generally a good thing.

In my mind, you work with what you have; you try to educate/instruct, but sometimes your best efforts do not work.

This issue is one of the reasons why I generally try and get user entered information via a userform. You have much better control and much better error-trapping available.

Of course having a userform is not always possible.

faq219-2884

Gerry
My paintings and sculpture

 

[macropod]

Hi gkhn,

You could use the technique at:

http://support.microsoft.com/?kbid=211219

to trap the Enter key. As coded, the macro there treats the Enter key as a Tab key. If you use multiple formfields, as BlueHorizon suggests, you could use the code as is. Alternatively, you could replace the trapped <Enter> with a <space> or some other character.

Cheers

[MS MVP - Word]