 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / October 2003Form field autofill?
Anyone know how to get a form field to automatically fill with information you type in a different field? I have a form that requires the same info to be enterd again and again. If these could be filled automatically it would speed up the process. Thanks! Kevin Try using only one formfield (the first one that the user reaches to fill in the information) and change its bookmark name from Text1 (or whatever) to something appropriate (like AcctTotal). Then change the other formfields to be bookmark references {REF AcctTotal *\Charformat} (always change mergeformat to charformat so that you have better control over the font, etc.). You will need to update the fields before printing (you can just write a keystroke macro that turns on printpreview and then immediately turns it off - works like a charm). It's a bit of a pain to print to file or keep your tool, options, print feature to update fields on print. You can also write a macro that will run when the field is exited that will update the other formfields. However, doing this enables the user to inadvertently change the values. Good luck. >-----Original Message----- >Anyone know how to get a form field to automatically fill [quoted text clipped - 5 lines] >Kevin >. No need for a macro if you check the field properties to require "calculate on exit" which should read "Update other fields that refer to this one on exit."  SignatureCharles Kenyon Word New User FAQ & Web Directory: <URL: http://addbalance.com/word/index.htm> Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) <URL: http://addbalance.com/usersguide/index.htm> See also the MVP FAQ: <URL: http://www.mvps.org/word/> which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. > Try using only one formfield (the first one that the user > reaches to fill in the information) and change its [quoted text clipped - 27 lines] > >Kevin > >. I am still having trouble having the form automatically fill in other form fields. You mentioned that a macro could be used to update the fields. Do you have an example of one that I could copy to do what I need? Thanks! >-----Original Message----- >Try using only one formfield (the first one that the user [quoted text clipped - 30 lines] >> >. >I am still having trouble having the form automatically >fill in other form fields. Set the properties so "Calculate on Exit" is checked. that will force an update of all REF fields that refers to it. Tsu Dho Nimh SignatureWhen businesses invoke the "protection of consumers," it's a lot like politicians invoking morality and children - grab your wallet and/or your kid and run for your life. just write a keystroke macro that turns on printpreview and then immediately turns it off >-----Original Message----- >I am still having trouble having the form automatically [quoted text clipped - 45 lines] >> >. >Anyone know how to get a form field to automatically fill >with information you type in a different field? I have a >form that requires the same info to be enterd again and >again. If these could be filled automatically it would >speed up the process. Thanks! EASY! ... The first field where this info is needed is a FORMTEXT field, given a bookmark name you can remember. The rest of tham are REF fields, referring to that bookmark. FORMTEXT = bookmark name "defendant" REF = bookmark name "defendant" The instant they tab out of the first field, the defendant's name appears everywhere. Tsu Dho Nimh SignatureWhen businesses invoke the "protection of consumers," it's a lot like politicians invoking morality and children - grab your wallet and/or your kid and run for your life. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.