Replies

I do not have the SMALL, MED, LARGE options, but you gave me enough that I did find how to change the font (That option button, Internet Options, Accessibility and check “Ignore Font Styles specified on Web Pages”. Then the Font button.) I do appreciate that because I can choose a clearer font. However, I wonder why I could not find the size buttons refered to in your answer.

Thanks

I think this is just what the doctor ordered for this client! I had never played with MS Draw, and it’s an oversight on my part! Many thanks.
ENA

The original request was for some way to go to a business, fill out 1000 questions – he is analyzing the business and he obviously has a lot of things to ask. Then he wants to have the report filled out automatically from his data input. He won’t have hundreds of records – just a few records with lots of fields. Thus no need for one-to-many links.

He was contemplating building the whole thing in Word, but he wanted choice lists and option lists (Yes/No/NA) for ease of data entry. I thought Access would prove easier to build the data entry part and that’s the way we started.

I need to consider your merge comments, but I think you are suggesting the report be broken into multiple documents – and that may work just fine. I wanted to know if I were overlooking something obvious or whether a work-around is available. You are telling me that there is no simple way to do what we need to do, and for that I thank you.
Nora

I’d love to find a non-VBA way to deal with this. I can’t do it with a query, because queries also have size limitations – probably the same number of fields as tables have (255). My data source is going to need all 999 or so fields!

I tried breaking the word document into sections and using different data sources for each section. That seemed like such a good idea that didn’t work.

Okay! Using the Autoshapes and connectors was one possibility – it’s nice to have someone confirm that it IS a good way to go. Thanks.
Nora

The project is an infrequent task – it won’t be worth purchasing a new program. MS Organizational Chart is available within either PowerPoint or Word – and that’s what they wanted to use. I just can’t find any way to make it do what they want – such things as 3 branches from the primary “box”, with one of those branches having 8 boxes spread horizontally across the page. This thing has 46 positions. It’s just shaped differently than any available Microsoft styles and bigger than Microsoft planned for these to be. Is there some way to tweak the existing styles into something unique?

Nora A.

Yes, I could. However, the survey is VERY long, and it would be far simpler to have data in an table or some easy-to-access object instead of scattered throughout individual combo boxes or text box formulas. Sorry I was so cryptic.

And thanks again

I agree, but this system will be used by parents and grandparents checking out kids, some of whom will use it infrequently. This will be the first time some of them have touched a mouse. A re-starting program will be more satisfactory. Unless the software company would remove the EXIT button.

Nora