Anyone???

Even if you don't know why I'm getting the error I'm getting, I would really appreciate it if someone could point me to the documentation that explains the syntax for DisplayFormat.

-Joe

--- In IBObjects@yahoogroups.com, "Joe" <joe@...> wrote:
>
> I am trying to use the DisplayFormat attribute to display a numeric value as curency (i.e. $12.33) in a TIB_Grid. The grid is attached to a TIB_Query.
>
> I set the DisplayFormat to: $###,###,##0.00
>
> When I have it set like that, if the grid attempts to display a value that has cents in it (that is, not a whole number), I get the following exception: "Project MYPROJECT.exe raised exception class EConvertError with message "1.45" is not a valid integer value"
>
> If I remove the DisplayFormat setting, I don't get the exception.
>
> The field in question is defined as a TIBOFloatField.
>
> Did I set the DisplayFormat incorrectly? I copied that value out of a past post, because I could not find any documentation on DisplayFormat, so while we're at it, can someone point me to a reference that explains the syntax of this setting?
>
> Thanks,
> Joe
>