Thank you for the help. Everday is a learning experience with R Base! -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, September 01, 2010 2:30 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Data Type and Display Format
At 02:16 PM 9/1/2010, Peter J Ryan wrote: >I am using Turbo 8. >In a report I have a Rich Text Object (letter or memo) with an insert >currency field for example $300.00 I wish to also display the words >THREE HUNDRED and xx/100 DOLLARS. >What does the display format of the currency field get set to? Peter, In order to achieve your goal, while in Report Designer, define a TEXT variable with the following expression: vCurrencyText = (DWRD(currencycolumnname)) Then, you can insert the vCurrencyText variable in Rich Text Object accordingly. You may further customize the expression as follows: vCurrencyText = (ICAP2(DWRD(currencycolumnname))) OR vCurrencyText = (LUC(DWRD(currencycolumnname))) Have fun! Very Best R:egards, Razzak.
