[RBASE-L] - Re: Data Type and Display Format

[A. Razzak Memon]

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.