If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fill in the blanks
I am creating forms for a police department and have a
question. I am creating the forms with tables and using form fields. I am wondering if it is possible to type in one field and have another field automatically fill in with text corresponding to what I typed in the first field. For example- I type in an activity code in the activity code field and I want the State statute that corresponds with that activity code to automatically be put in the state statute field. Is this possible? |
#2
|
|||
|
|||
Bonjour,
Dans son message, Signe écrivait : In this message, Signe wrote: || I am creating forms for a police department and have a || question. I am creating the forms with tables and using || form fields. I am wondering if it is possible to type in || one field and have another field automatically fill in || with text corresponding to what I typed in the first || field. For example- I type in an activity code in the || activity code field and I want the State statute that || corresponds with that activity code to automatically be || put in the state statute field. Is this possible? Use {REF} fields where you want the repeated text. E.g: On page one, you have a text field named "Text1" (right click the field, click properties, and see/change the name where it says Bookmark, bottom right corner). everywhere else you want Text1 to appear do: CTRL-F9; A pair of { } will appear; Type REF Text1 between the curly braces; Create all the REF fields you want; In the field where the text originates, make sure to check the "calculate on exit" checkbox so that all REF fields will be updated automatically when leaving the text fields; Finally, do ALT-F9 twice to turn the REF fields into their values (They will seem to disappear the first time as they will be linked to empty fields); Lock the form; Type some text in Text1; See all the REF Text1 field update when you tab out of Text1. -- Salut! _______________________________________ Jean-Guy Marcil - Word MVP ISTOO Word MVP site: http://www.word.mvps.org |
#3
|
|||
|
|||
You can use the technique or a variation of it to insert the texts based on
the codes shown at http://www.gmayor.com/SelectFile.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Signe wrote: I am creating forms for a police department and have a question. I am creating the forms with tables and using form fields. I am wondering if it is possible to type in one field and have another field automatically fill in with text corresponding to what I typed in the first field. For example- I type in an activity code in the activity code field and I want the State statute that corresponds with that activity code to automatically be put in the state statute field. Is this possible? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Auto fill criteria/questions on filling formulas down | JAnderson | General Discussion | 2 | July 19th, 2004 09:45 PM |
Vlookup value from fill colour only. | shital | Worksheet Functions | 1 | June 7th, 2004 02:34 PM |
Pivot Table - fill in the blanks | Megan | Worksheet Functions | 4 | March 22nd, 2004 09:07 PM |
Changing fill color gradient on chart | melissa | Charts and Charting | 1 | February 21st, 2004 01:03 AM |
fill in blanks | michele | Worksheet Functions | 1 | October 29th, 2003 01:38 PM |