Is there a way to make a text field {FORMTEXT} appear through an IF condition?
If I select "other" in a drop down, to allow an empty form field to appear to input a number.

For the calculations, I was originally using bookmarks for the field. With the drop down example the numbers generated from the IF condition don't have a bookmark associated with them. What do you put in place of a bookmark for expressions from those numbers?



For FormFields - Table Row Add.doc example - When I run this macro in another document with nested tables I get this error

Microsoft Visual Basic for Applications
"X Cannot access individual rows in this collection because the table has vertically merged cells."

The nested table doesn't have any merged cells so I'm not sure how to fix this.

Current version of form attached.

Attached Files

2016 EOD Form Form Fields.docm (42.5 KB, 12 views)

No. A macro would be required for that. See: Word 2010 template form field (If checkbox is checked display another field else do not display)

Alternatively, to simulate a combobox, see: https://www.msofficeforums.com/17071-post2.html
When you insert a dropdown formfield into a document, Word gives it a default bookmark name (e.g. Dropdown1). You can see that when you examine the formfield's properties; you can also delete it or change it to something else.
Your table does have vertically merged cells. See item 8. Furthermore, the macro isn't designed to work with nested tables, so I don't know how you'll get along with that.

PS: It would be preferred for you to attach files here, rather than linking to them on another site. You can do that via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I'm talking about this:
Dept = { FORMDROPDOWN }
{IF{REF Dropdown1 \* MERGEFORMAT}= "HR" "001"}
When the number, in this case 001, is generated by the IF condition, how do you use that number in a calculation/formula? The "001" has no bookmark to use in another formula. What would be the reference?

I tried just using the same formula and adding the calculation into it
{={IF{REF Dropdown1 \* MERGEFORMAT}= "HR" "001"}*(REF UXOQTY1}} but it doesn't work.

In my form I want the N.E.W. (from the selection made in Dropdown UXONomen01) * UXOQTY1 to be calculated and shown in the TOTAL N.E.W.
Since the TOTAL N.E.W. textfield relies on bookmarks to do a calculation (right?), I'm guessing it would have to be done outside of the field's properties.

I'm not sure how else to explain what I'm trying to do here.

Using this I put the sample into a vertically and horizontally merged table an it still works. Not sure what the difference is between what I'm doing with the sample and my working form.

The 001 is simply the displayed output. You don't reference that in a calculation; only whatever Dropdown1 returns. You can also lose the ' \* MERGEFORMAT' - it's quite unnecessary. So, if you want to use th, you'd code along the lines of:
{={IF{REF Dropdown1}= "Finance" 2 {IF{REF Dropdown1}= "HR" 1 0}}*5}
where 5 is whatever you want to multiply the selected item's value by. However, that's really no different than:
{IF{REF Dropdown1}= "HR" 5}{IF{REF Dropdown1}= "Finance" 10}
I suggest you take a look at my Microsoft Word Field Maths Tutorial, available at:
http://windowssecrets.com/forums/sho...Maths-Tutorial
and:
http://www.gmayor.com/downloads.htm#Third_party

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I'm sure a lot of it is due to the fact that I have no idea what I'm actually doing, but...

When I am in ALT-F9 view and putting in the code/formula it doesn't always "activate". Is there something else I should be doing? When I go back to normal view the formula is sometimes written out as it is rather than being "invisible".

Forgive my terminology... I'm still learning to speak code.

I'm still struggling the get numbers from a dropdown condition to multiply with a FORMTEXT field number. I've tried various ways explained in the tutorial. Again, I'm sure I'm either doing it wrong or assuming one thing works with another when it doesn't.

Is there a way to use the displayed output in a separate calculation? That's what I've been trying to do.

I tried using the table cell address that contains the output, but I'm guessing that's not an option either.