Subject Re: [IBO] Re: DisplayFormat issue - EConvertError
Author Helen Borrie
>From: "Joe" <joe@...>
>> Woody,
>>
>> It seems to happen no matter which numerical field I put the formatting
>> on. I've tried ITEMCOST, and I've tried ITEMTOTAL (separately, one at a
>> time), and either one will cause the error.
>>
>> Also, the error only occurs if the value in the formatted field contains a
>> fractional (cents) amount. If the field contains only whole dollar
>> amounts (i.e. 1.00), the error does not occur.
>>

At 09:39 AM 24/11/2010, Woody wrote:

>I'm inclined to think it's a compatibility issue somewhere. What database
>and version are you using?

Besides saying which fields are causing this problem, also indicate what data type it is (or they are) in the database and how you are casting it (them) in the dataset - including the CalculatedFields! Also, can't see any sign in the DFM that you have set any of these fields as Currency.

Helen