Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
Hi to everyone, this is my first post in this forum Hope that someone can help me and that my question is not already published on the board (if so, I'm sorry but i wasn't able to find it :P) My problem is: I want to do a form, in which I need to use a dropdown menu at the beginning that allows me to select between "Mr." and "Miss". I would like that in the rest of the text, evreytime i need to use a pronoun like his or her, automatically every pronoun will be changed according to the selection in the dropdown menu, E.g. if I choose "Miss" in the dropdown every pronoun have to switch to "her"... if I choose "Mr.", the same spots need to be changed in "his"... Is there any solution to this?? I don't know if the question is clear..sorry for bad english! Thanks in advance -- revolution21 |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
Hi revolution21,
All you need to do with your dropdown field, note it's bookmark name and set its properties to 'calculate on exit. Then, wherever you want the results of the dropdown selection replicated, insert a cross-reference (via Insert|Cross Reference) pointing to the dropdown's bookmark. When you're done, protect the document for forms. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "revolution21" wrote in message ... Hi to everyone, this is my first post in this forum Hope that someone can help me and that my question is not already published on the board (if so, I'm sorry but i wasn't able to find it :P) My problem is: I want to do a form, in which I need to use a dropdown menu at the beginning that allows me to select between "Mr." and "Miss". I would like that in the rest of the text, evreytime i need to use a pronoun like his or her, automatically every pronoun will be changed according to the selection in the dropdown menu, E.g. if I choose "Miss" in the dropdown every pronoun have to switch to "her"... if I choose "Mr.", the same spots need to be changed in "his"... Is there any solution to this?? I don't know if the question is clear..sorry for bad english! Thanks in advance -- revolution21 |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
But he doesn't want the results of the dropdown. He wants his/her, him/her,
etc., based on whether the choice is Mr., Miss, Ms, Mrs., etc. This is probably a better job for a UserForm, and it's something that can be done by Bill Coan's DataPrompter (http://www.wordsite.com/products/dpdas.htm). -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA "macropod" wrote in message ... Hi revolution21, All you need to do with your dropdown field, note it's bookmark name and set its properties to 'calculate on exit. Then, wherever you want the results of the dropdown selection replicated, insert a cross-reference (via Insert|Cross Reference) pointing to the dropdown's bookmark. When you're done, protect the document for forms. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "revolution21" wrote in message ... Hi to everyone, this is my first post in this forum Hope that someone can help me and that my question is not already published on the board (if so, I'm sorry but i wasn't able to find it :P) My problem is: I want to do a form, in which I need to use a dropdown menu at the beginning that allows me to select between "Mr." and "Miss". I would like that in the rest of the text, evreytime i need to use a pronoun like his or her, automatically every pronoun will be changed according to the selection in the dropdown menu, E.g. if I choose "Miss" in the dropdown every pronoun have to switch to "her"... if I choose "Mr.", the same spots need to be changed in "his"... Is there any solution to this?? I don't know if the question is clear..sorry for bad english! Thanks in advance -- revolution21 |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
"Suzanne S. Barnhill" wrote in message ...
But he doesn't want the results of the dropdown. He wants his/her, him/her, etc., based on whether the choice is Mr., Miss, Ms, Mrs., etc. Missed that. Still, easily enough done with an IF test at each location: {IF{Dropdown1}= "*s" her his} or {IF{Dropdown1}= "*s" her him} or {IF{Dropdown1}= "*s" she he} depending on the context. Cheers -- macropod [MVP - Microsoft Word] ------------------------- |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
macropod;2730901 Wrote: Missed that. Still, easily enough done with an IF test at each location: {IF{Dropdown1}= "*s" her his} etc... Thanks for your answers.. but it seems not to work :-/ I used an IF field as you wrote { IF { Gender } = "Miss" her his }, named the dropdown menu "Gender" and checked the "calculate" box... but the IF field is always on "his", even if i change the choice in dropdown and then refresh. Do you know any another possible solution or am I missing something? -- revolution21 |
#6
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
Hi revolution21,
The test is case-sensitive, so make sure that the capitalisation in you dropdown and IF test match. Make sure too that there are no unnecessary spaces in the choices assigned in the dropdown or in the IF test (eg "Miss "). Also, the field coding I posted obviates the need to know whether you're using Mr, Master, Mrs, Miss or Ms. It does this by using the * wildcard to represent all except the last character. If (as convention says you should) the abbreviated forms are followed by a period (ie Mr., Master, Mrs., Miss or Ms.), you could change the IF tests to: {IF{Gender}= "*s?" her his} or {IF{Gender}= "*s?" her him} or {IF{Gender}= "*s?" she he} depending on the context. This adds the ? wildcard to force the IF test to examine the penultimate character. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "revolution21" wrote in message ... macropod;2730901 Wrote: Missed that. Still, easily enough done with an IF test at each location: {IF{Dropdown1}= "*s" her his} etc... Thanks for your answers.. but it seems not to work :-/ I used an IF field as you wrote { IF { Gender } = "Miss" her his }, named the dropdown menu "Gender" and checked the "calculate" box... but the IF field is always on "his", even if i change the choice in dropdown and then refresh. Do you know any another possible solution or am I missing something? -- revolution21 |
#7
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
In addition to Macropod's comments, did you use CTRL+F9 for the brackets
around Gender? Without them it will always show 'his'. Also did you tab out of the Gender field? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org revolution21 wrote: macropod;2730901 Wrote: Missed that. Still, easily enough done with an IF test at each location: {IF{Dropdown1}= "*s" her his} etc... Thanks for your answers.. but it seems not to work :-/ I used an IF field as you wrote { IF { Gender } = "Miss" her his }, named the dropdown menu "Gender" and checked the "calculate" box... but the IF field is always on "his", even if i change the choice in dropdown and then refresh. Do you know any another possible solution or am I missing something? |
#8
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
Graham Mayor;2732130 Wrote: In addition to Macropod's comments, did you use CTRL+F9 for the brackets around Gender? Without them it will always show 'his'. Thank you so much to macropod and graham! now it works! I think brackets were wrong in my first attempt. Thank you again mates. -- revolution21 |
#9
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
Hi again I've another difficult (for me :P) task that maybe requires an IF field. I've to prepare a form for a sort of income. It works this way: gross amount = X ("Lordo") tax 20% = Lordo/5 ("Imponibile") net amount = Lordo - Imponibile in this form, inserting the gross amount it's possible to know the net amount. I assigned a bookmark to the gross amount text field ("Lordo"), then another one to the function to know the amount of the tax ("Imponibile"), then the final function subtracting the tax amount from the gross amount. The problem is: in Italy you have two different rates for taxes: one is 20% (like in the example shown), another is 30%. I would like to allow a choice between the two tax amounts, and then I would like that the form will be able to calculate depending on the choice of the tax amount. Is there a way to do that? By the way, to calculate the 30% tax amount i used this forumla: (Lordo x 3)/10. thanks in advance for you help! -- revolution21 |
#10
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
Insert three textbox formfields into your document and a dropdown formfield
to which you add (via its properties dialog) the entries 20% and 30% and have a macro containing the following code run on exit from the dropdown formfield Dim rate As Long With ActiveDocument If .FormFields("Dropdown1").DropDown.Value = 1 Then rate = 20 Else rate = 30 End If If IsNumeric(.FormFields("Text1").Result) Then .FormFields("Text2").Result = .FormFields("Text1").Result * rate / 100 .FormFields("Text3").Result = .FormFields("Text1").Result * (1 - rate / 100) Else MsgBox "You must enter a numeric value" End If End With The macro assumes that the name of the bookmark assigned to the formfield into which the gross amount will be entered is Text1 and the amount of the tax will be shown in the formfield Text2 and the net amount after tax will be shown in Text3 -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "revolution21" wrote in message ... Hi again I've another difficult (for me :P) task that maybe requires an IF field. I've to prepare a form for a sort of income. It works this way: gross amount = X ("Lordo") tax 20% = Lordo/5 ("Imponibile") net amount = Lordo - Imponibile in this form, inserting the gross amount it's possible to know the net amount. I assigned a bookmark to the gross amount text field ("Lordo"), then another one to the function to know the amount of the tax ("Imponibile"), then the final function subtracting the tax amount from the gross amount. The problem is: in Italy you have two different rates for taxes: one is 20% (like in the example shown), another is 30%. I would like to allow a choice between the two tax amounts, and then I would like that the form will be able to calculate depending on the choice of the tax amount. Is there a way to do that? By the way, to calculate the 30% tax amount i used this forumla: (Lordo x 3)/10. thanks in advance for you help! -- revolution21 |
#11
Posted to microsoft.public.word.newusers
|
|||
|
|||
IF field? and if so, how to set up it??
If I understand correctly, yoiu have a form field "Lordo" which contains a
gross amount and a form field "Imponibile" which contains 20% or 30%? In which case a pair of formula fields will work { ={ Lordo } * { Imponibile } } and for the net amount { ={ Lordo } - ({ Lordo } * { Imponibile }) } It would probably be sensible to use a dropdown formfield for the tax amount containing 20% and 30% as values. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org revolution21 wrote: Hi again I've another difficult (for me :P) task that maybe requires an IF field. I've to prepare a form for a sort of income. It works this way: gross amount = X ("Lordo") tax 20% = Lordo/5 ("Imponibile") net amount = Lordo - Imponibile in this form, inserting the gross amount it's possible to know the net amount. I assigned a bookmark to the gross amount text field ("Lordo"), then another one to the function to know the amount of the tax ("Imponibile"), then the final function subtracting the tax amount from the gross amount. The problem is: in Italy you have two different rates for taxes: one is 20% (like in the example shown), another is 30%. I would like to allow a choice between the two tax amounts, and then I would like that the form will be able to calculate depending on the choice of the tax amount. Is there a way to do that? By the way, to calculate the 30% tax amount i used this forumla: (Lordo x 3)/10. thanks in advance for you help! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form field entry extends field beyond page margin | Microsoft Word Help | |||
File Name Field With Text Form Field When Performing a Save As... | Microsoft Word Help | |||
MailMerge Through VBA Printing Actual Field Names NOT Field Values | Mailmerge | |||
Copy portion of text form field , the field is in a table cell | Tables | |||
Help on Mailmerge field (field length) - field getting truncated | Mailmerge |