Help with Drop downsfor word documents

[Terry]

I need to have a way to put together information for a paragraph by using
numerous data fields. I have so many that Access can not handle them for a
single report. Is there anyway to do this on word with check boxes or drop
downs so that it prints with just the information that is needed?
Thanks for any help anyone can give me.

 

[Tony Jollans]

I have so many that Access can not handle them for a

single report.

I find this hard to believe but, if true, your paragraph is too long.

It could be done in Word but where are the data coming from?

 

[Terry]

Well I was using check boxxes for each field. ie; if box 3-13a is marked,
then the text "THe brown lazy fox" is input into the paragrapgh. While the
information is not huge, there has to be alot of text boxes because each box
represents something different. Not every box will be checked everytime, but
usually 3-4 at a time. At last count there was 415 check boxes. When I
seperate them in to various queries it can be handled. But wehn I try to
combine them on a report, it becomes too many. Thanks for you time on this.

 

[Tony Jollans]

I'm finding this hard to imagine - over 400 checkboxes from which the user
is expected to choose 3 or 4 on average; I'm real glad I'm not one of your
users.

What is the make up of your document - does it have standard paragraphs and
a few extra optional bits, or what? Presumably you had an Access Form - A
Word UserForm would be a rough equivalent and should be able (technically)
to accommodate the checkboxes. The text fragments could be autotexts so they
shouldn't be any problem. It can be done but there must be an easier way of
organising it.

 

[Terry]

Yes its mostly standardized paragraphs. The check boxes are in reference to
a manual we have to type out for paragraph number 2 and yes, it is alot of
information to look through. Thats why we were trying to create check boxes
for auto insert of text. We are given a list of numbers and tehn we have to
look through the book to look the numbers up. But if we have check boxes we
could speed it up just by looking up the number.

 

[Tony Jollans]

Technically I don't see a problem but I still have real conceptual problems.
Somebody who knows what they want gives you some numbers to look up so you
can enter different numbers to reproduce it. Still, if that's what you've
got to do, I can see you want to simplify it - but wouldn't it be easier
just to type the numbers in and let the machine do the work?

Whatever the details of the interface, create a template (.dot file) with
the fixed text in place and bookmarks where the variable text has to go.
Create a userform and an AutoNew macro which displays it, gets the
information off the user, and loads the bookmarks with the appropriate text.
It should all run when you then create a document based on the template.