 |
 | 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 / Mailmerge and Fax / August 2004Auto Text Fields in word
I have an Auto Text field that is filled out by an application. The text that is populated happens to be a date and time, I need to create another field in the same document that references the Auto Text field and do some date math on it. Is it possible to reference an Autotext field in a formula? I've tried and not been very successful. If not a formula how should I go about doing this? Thanks Wayne Calculations on date fields are extremely complex - see http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I have an Auto Text field that is filled out by an application. The > text that is populated happens to be a date and time, I need to [quoted text clipped - 7 lines] > Thanks > Wayne I found that yesterday, however it deals with DATE Fields. What I have isn't a DATE FIELD but an AUTO TEXT field. I've not figured out how to use the AUTO TEXT field in a formula yet, even something as simple as just saying Formula=MyAutoTextField Thanks Wayne > Calculations on date fields are extremely complex - see > http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902 [quoted text clipped - 10 lines] > > Thanks > > Wayne Your original post stated that the field was populated by date and time information. It doesn't matter where you derive the information from, if you are performing calculations on dates then the complication addressed remains. For simple numbers you can insert an autotext field in a calculation e.g. {={Autotext Name}+5} but this will not work for dates. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I found that yesterday, however it deals with DATE Fields. What I > have isn't a DATE FIELD but an AUTO TEXT field. I've not figured out [quoted text clipped - 26 lines] >>> Thanks >>> Wayne Well it is actually a date that I am putting into the Autotext, so I guess its a date field. I'm fairly new at using word, up till now it was just a spell checker for me. as for the below {={Autotext Name}+5} I've tried this, and referenced one of my Autotext fields that result in a simple integer being placed in the field. Typing it in as you have it, replacing "Name" with the name of my autotext field, InspectionID, I receive the following error: !Syntax Error, { not sure if it's complaining about the first or second {, if I change the {} to () I then get a syntax error on InspectionID. Any other ideas? Thanks Wayne > Your original post stated that the field was populated by date and time > information. It doesn't matter where you derive the information from, if you [quoted text clipped - 13 lines] > > > >> Calculations on date fields are extremely complex - see http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902 > >> -- > >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> [quoted text clipped - 15 lines] > >>> Thanks > >>> Wayne The curly brackets are placed with CTRL+F9 and not typed from the keyboard. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Well it is actually a date that I am putting into the Autotext, so I > guess its a date field. I'm fairly new at using word, up till now it [quoted text clipped - 66 lines] >>>>> Thanks >>>>> Wayne I've done that and it gives me the error. I've also chose insert --> Field --> Formula, but still get the same error. Thanks Wayne > The curly brackets are placed with CTRL+F9 and not typed from the keyboard. > [quoted text clipped - 68 lines] > >>>>> Thanks > >>>>> Wayne Your autotext entry must contain something other than a number. Type the number 5 in a line of text in a document. Select the 5 (but not the space on either side). Save it as an autotext entry called Name Press CTRL+F9 - {} between the brackets type = + 5 {=+5} between the = and + signs Insert > field > autotext > Name Select the fields and press ALT+F9 - then F9 to update The display should show 10 Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I've done that and it gives me the error. I've also chose insert --> > Field --> Formula, but still get the same error. [quoted text clipped - 85 lines] >>>>>>> Thanks >>>>>>> Wayne THANK YOU!!!!!!! That works perfectly, time go look at the date document and figure out how to update my date/time now. Thanks Wayne > Your autotext entry must contain something other than a number. > Type the number 5 in a line of text in a document. Select the 5 (but not the [quoted text clipped - 74 lines] > >>>>> > >>>>>> Calculations on date fields are extremely complex - see http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902 > >>>>>> -- > >>>>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<> [quoted text clipped - 16 lines] > >>>>>>> Thanks > >>>>>>> Wayne |
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.