I am using word 2007 and form will be used in word 2010. I am doing a form, which will be protected and using a control drop down box. The drop down box is used for meal plans and needs to populate as 3 separate lines, breakfast, lunch, dinner. Is this possible? or is there another choice besides a drop down box. I have drop down box that states:

Meal Plan A
Meal Plan B
Meal Plan C



Once selected I would like it to auto text the following:

If Meal Plan A chosen:

Breakfast: 3 starch, 1 dairy, 1 fruit, 2 fats
Lunch: 3 protein, 3 starch, 1 veg, 1 fruit, 1 dairy, 2 fats
Dinner: 3 protein, 2 starch, 1 veg, 1 fruit, 1 dairy, 2 fats

(would like all of the beginnings to line up ie all the 3's)

and Meal Plan B has differences, but same concept. The format of 3 separate lines is important.

Thanks so much for any help that anyone can lend, have been at this for a while and cannot come up with anything to keep alignment, etc.

It is fairly straightforward to do this. See the example attached. Obviously I don't know what the meal plans B and C are so I have made them all the same, but if you unlock the form and press ALT+F9 you will see the construction and you can make your changes to the plans. Note the three statements follow each other with no space between them.

The alignment is maintained with tabs. The default tabs are re-set at 2.25cm. You can change that as you wish to get the alignment you want.

Tab out of the dropdown field to make the change (for which you need at least two fields on the form).

Attached Files

Meals.docx (22.3 KB, 21 views)

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Thank you so much for your reply, i have been working on this for a while, but i am not quite sure where or how to insert in my macro i have developed. I have attached the form and you obviously will be able to see the macro and perhaps could help me with where to insert. The location of field is on the 3rd page. Again, will this work with the form protected?

Attached Files

RTC-ADRR-112014-test.docm (158.1 KB, 13 views)

The 'code' I posted is not part of a macro. You cannot achieve exactly what you have attempted with a macro. You could use it to write to the cell directly, though that would need the form to be unlocked. In fact there is no need for a macro to do this. You can use a conditional field (or fields) and that is what I have posted. I have inserted it into your form so you can see how it works. Select a meal and tab out of the field. (I think I have the meals right but please check).

It also entailed setting the default tabs at a new value, which affects the whole form. You may need to check your tabs and apply paragraph format tabs as required.

Attached Files

RTC-ADRR-112014-test.docx (164.9 KB, 18 views)

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

I cannot say thank you enough. This was the first form that I had to reconstruct from something that someone else started and that had me stumped. Thanks again, you are a wonderful person.

You are welcome Please mark the thread as solved.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com