combine the content in multiple field into 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ah - 27 Jul 2006 08:42 GMT

I've created a human resource form and there is 1 field for them to fill in
their bank Account.

In order to ensure the users enter the correct bank account(16 digit bank
account), I've set in 16 column for the bank account field as the users seem
to miss out some of the digit frequently.

Besides, I also formatted the form so that users cannot ammend my form.
However, I faced the following problem with this:

a) Once my staff receive the filled in form, they need to enter the data
into a system. In order to avoid typo errors, I want them to use the "copy
and paste" approach. ,i.e copy directly from the form and paste it to the
system field.

In this case, as I've 16 columns with 16 text field box, the system does not
allow me to copy the bank account number at 1 go. I need to copy it 1 by 1,
from the 1st column up to the 16th column.

I would appreciate if someone could help me on this. Is there any
alternative solution to solve this?
Please advice.

Reply to this Message

Cindy M -WordMVP- - 27 Jul 2006 15:19 GMT

Hi =?Utf-8?B?YWg=?=,

You don't specify what kind of "field" you're using per table cell; I'm going
to assume you're using form fields from the Forms toolbar.

I might consider going back to a single field. Format it with a
non-proportional font, such a Courier New. Set the character spacing to a high
expansion, so that the characters will appear far apart. Set the form field to
allow exactly 16 characters.

In the next paragraph, use the same character spacing. Set an exact line
height, and make it quite small. Type 16 underscores _. When the user types in
the field, the characters should align over the underscores, providing the
necessary visual cue.

> I've created a human resource form and there is 1 field for them to fill in
> their bank Account.
[quoted text clipped - 17 lines]
> I would appreciate if someone could help me on this. Is there any
> alternative solution to solve this?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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 :-)

Reply to this Message

ah - 28 Jul 2006 02:15 GMT

Hi Cindy;

Thanks for your reply.
Yup, you are right. I'm using the form field.I'm a bit confuse with your 2nd
step as follows:

> In the next paragraph, use the same character spacing. Set an exact line
> height, and make it quite small. Type 16 underscores _. When the user types in
> the field, the characters should align over the underscores, providing the
> necessary visual cue.

Do I need to set another form field for this?If I set a form field, it
doesn't allow me to key in the underscore.

Please advdice.

> Hi =?Utf-8?B?YWg=?=,
>
[quoted text clipped - 40 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)

Reply to this Message

ah - 28 Jul 2006 04:06 GMT

Hi Cindy;

I found out that I can draw the underscore via "font-underline style"
Are you refering to this?

However, I found that the maximum underscore line taht it appears in 1 form
field is 5 only. How can I make it as 16 in stead of 5? FYI, the scale size
taht I'm using now is alraedy 160%

> Hi Cindy;
>
[quoted text clipped - 56 lines]
> > This reply is posted in the Newsgroup; please post any follow question or reply
> > in the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M -WordMVP- - 28 Jul 2006 15:26 GMT

Hi =?Utf-8?B?YWg=?=,

> > In the next paragraph, use the same character spacing. Set an exact line
> > height, and make it quite small. Type 16 underscores _. When the user types in
[quoted text clipped - 3 lines]
> Do I need to set another form field for this?If I set a form field, it
> doesn't allow me to key in the underscore.

After you've created the form field, move to the right of the form field and press
ENTER (creates a new paragraph).

Format/Paragraph. Set the line spacing to "Exact" and a measurement of something
like 3 pts, to start. (This is to move the underscores up, closer to the form field
in the preceding paragraph.) Now type underscore 16 times.

Note: if you want the user to see the form field as wide as the underscores, you
can enter 16 characters as the "default" in the form field options. Type 16 X
characters, for example.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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 :-)

Reply to this Message

ah - 01 Aug 2006 02:28 GMT

Hi Cindy;

Thanks for the solution given.I've tried it out, it works. But, I still have
a concern as follows:

1. In your previous reply, you stated that if I want to see the form field
as wide as the underscore, I need to key in some characters in the default
number.
However, I'm not be able to place in a default number. This is due to the
fact that it is a bank account field. If I place in the default numbers as
sixteen zero, there might be a possibilities that users have left out 1 or 2
digit when they fill in the form, while my system will capture it as zero
then.

Please advice.
Thanks in advance.

> Hi =?Utf-8?B?YWg=?=,
>
[quoted text clipped - 24 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply in
> the newsgroup and not by e-mail :-)

Reply to this Message

Cindy M -WordMVP- - 01 Aug 2006 11:19 GMT

Hi =?Utf-8?B?YWg=?=,

> Thanks for the solution given.I've tried it out, it works. But, I still have
> a concern as follows:
[quoted text clipped - 7 lines]
> digit when they fill in the form, while my system will capture it as zero
> then.

Mmmm. You never explicitly said the field needs to be numeric ("bank account"
could also include letters). I was thinking of a "Regular text" field. Since
you've posted in a VBA group, you could use a macro to check whether the
content is numeric? That would be "safer", anyway, since a form field set to
"Number" also accepts letters such as h, t and s...

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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 :-)

Reply to this Message