Error In Formula Unexpected End Of Formula
be down. Please try the request again. Your cache administrator is webmaster. Generated Mon, 10 Oct 2016 06:03:20 GMT by s_ac4 (squid/3.5.20)
visit from the selection below. Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Microsoft Word Help Error - UNEXPECTED END OF FORMULA Author Name Remember Me? Password Site Map Home Register Authors List Today's Posts Search Web Partners Search Forums Show Threads Show Posts Advanced Search Go to Page... Error - UNEXPECTED END OF FORMULA « Previous Thread | Next Thread » Thread Tools Display Modes #1 November 16th 07, 04:38 PM posted to microsoft.public.word.docmanagement Dee external http://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_mac/autosum-says-unexpected-end-of-formula-when-i/57398214-3cc3-4696-8c43-d4de69c41077 usenet poster Posts: 98 Error - UNEXPECTED END OF FORMULA I'm using Word 2003, creating a form fill document using fields/formulas to pull data from a source in a custom program which is integrated with Word. I’ve entered a formula to pull a dollar value from the data. If there is an amount in the field in the form it pulls perfectly with the commas http://www.wordbanter.com/showthread.php?t=94698 in the correct places. However, if the field in the data base is blank I get the following error message UNEXPECTED END OF FORMULA. My formula looks like this: ${=DATA FIELD\# #,###} It's ok if the field is left blank, in other words, I don't need to use an IF statement to remove the blank space. What am I doing wrong? Why isn't just leaving the field in my document blank if the field in the data base is blank? Thx Dee View Public Profile View message headers Find all posts by Dee Find all threads started by Dee Ads #2 November 16th 07, 07:58 PM posted to microsoft.public.word.docmanagement macropod external usenet poster Posts: 1,002 Error - UNEXPECTED END OF FORMULA Hi Dee 'DATA FIELD' doesn't represent a valid filed name. So, what you've got is Word trying to evaluate '=' (ie equal to or less than)DATA against 'FIELD' followed by '' (ie greater than) '\#'. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Dee" wrote in message ... I'm using Word 2003, creating a form fill document using fields/formulas to pull data from a source in a custom program which is integrated with Wor
Blogs Gallery Community Community Links Social Groups Pictures & Albums Members List Go to Page... Error - UNEXPECTED END OF FORMULA Microsoft Office Word Page 1 of 2 1 2 > View First Unread Thread http://www.techtalkz.com/microsoft-office-word/172722-error-unexpected-end-formula.html Tools Display Modes 16-11-2007, 05:04 PM #1 Dee Guest Posts: n/a Error - UNEXPECTED END OF FORMULA I'm using Word 2003, creating a form fill document using fields/formulas to pull data from a source in a custom program which is integrated with Word. I’ve entered a formula to pull a dollar value from the data. If there is an amount in the field in the form it pulls perfectly error in with the commas in the correct places. However, if the field in the data base is blank I get the following error message UNEXPECTED END OF FORMULA. My formula looks like this: ${=\# #,###} It's ok if the field is left blank, in other words, I don't need to use an IF statement to remove the blank space. What am I doing wrong? Why isn't just leaving the field in my error in formula document blank if the field in the data base is blank? Thx Sponsored Links 16-11-2007, 08:01 PM #2 macropod Guest Posts: n/a Re: Error - UNEXPECTED END OF FORMULA Hi Dee '' doesn't represent a valid filed name. So, what you've got is Word trying to evaluate '=<' (ie equal to or less than)DATA against 'FIELD' followed by '>' (ie greater than) '\#'. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "Dee"