View Single Post
  #5   Report Post  
Posted to microsoft.public.word.formatting.longdocs
Tony Robbins[_2_] Tony Robbins[_2_] is offline
external usenet poster
 
Posts: 2
Default Hiding "Overflow" Linked Text Box when Empty

"John McGhie [MVP Word, Word Mac]" wrote:

Hi Tony:

That's what a Linked Text Box *is* -- an overflow field :-)


Exactly.

If you build this using just a table without any text boxes, then you won't
get a second page unless you need one. That's what I meant by "Do you
really need a text box?" If you can do this with a table only, it will grow
only if it needs to. You might use two tables: one for the top of the form,
and another immediately following for the expandable area.


The problem is that, if the table gets overfilled, it pushes information
down. I need the additional data to get moved to a second page, *after* the
remaining contents of the form. However, if I put an overflow textbox on
page 2, I still get page 2 even if the contents are empty.

I'm still surprised there's not a non-scripty solution. A lot of forms have
a small text field on a first page and then ask you to attach additional
information on additional sheets. I'm just trying to automate this on a form.

Thanks for your ideas,
Tony

Hope this helps

--

Please reply in the group. Please do NOT email me unless I ask you to.

http://jgmcghie.fastmail.com.au/

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
Sydney, Australia. GMT + 10 Hrs
+61 4 1209 1410,

"Tony Robbins" wrote in message
...
The issue is that I'm converting a paper form to digital. As it stands,
I've
got a text field sitting in a table. If you overfill the table, the form
"breaks" and starts to fill two pages. I'd prefer it to create the second
page to overflow, though your recommendation is fair. I could put a macro
in
that completes the form and deletes the unnecessary area -- or at least, I
could try.

It's preferable to teaching several non-user to light-user employees to
delete the 2nd page in the vast majority of cases. These note forms are
generally very brief, so the overflow is an exceptional case and not the
rule.

I am a little surprised though -- it seems like having an overflow field
for
text that is too big for its text area wouldn't be so out of the ordinary.
Are there any other solutions?

"John McGhie [MVP Word, Word Mac]" wrote:

Hi Tony:

Ask yourself if you REALLY need to do this with Text Boxes. I would try
very hard to return the answer "No" to that question.

Otherwise, yes, you will need some serious VBA to compute that the text
box
needs to overflow, create the second text box if it does, and link it.

It may be a lot simpler to create VBA that simply determins whether the
end
of the text is in Text Box A or B, and deletes B if it's empty :-)

Had you thought that maybe having a second empty page is really not such
a
bad thing? :-)

Cheers

--

Please reply in the group. Please do NOT email me unless I ask you to.

http://jgmcghie.fastmail.com.au/

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
Sydney, Australia. GMT + 10 Hrs
+61 4 1209 1410,

"Tony Robbins" Tony wrote in message
...
Aloha all,

I am trying to a form for work under Word 2003. The form itself has
two
text (A and B) boxes, each of which is linked to an overflow text box
(A2
and
B2). If there is too much text in textbox A, I want it to create a
textbox
A2 on page 2 where it continues the data.

Now, simply linking the text boxes will create the effect, except it
leaves
a second page on every form that doesn't need it. Rather than leaving
the
linked text box (A2) in, I'd like to make it dynamically created or
hidden
unless textbox A has overflowed.

This is slightly more complicated because I want similar behavior from
textbox B and B2.

Any suggestions? Do I need to use VBA for this or is there a simpler
method
I haven't tracked down?

Thanks!
Tony