I would simply flag the affected field as currency in the ColumnAttributes
Tab of the IB_Query...but check that your FieldProperties are empty for
displayFormat and EditMask as otherwise the columnattribute gets ignored!

Anyway, if you do not want to use the ColumnAttributes for whatever reason,
you will have to use the syntax of the FormatFloat or FormatmaskText
functions and not the format-strings syntax (the sysntax you used here) as
that will be ignored. Typical displayFormat-entries look like #00.00 or
so.....

Nick Josipovic
CRM Administration
BIT-Institute
Prof. Dr. Franz Steffens
Schloss
68163 Mannheim
Germany
Phone: ++49 621 181-1621
Fax: ++49 621 181-1618
mailto:nick.josipovic@...

> -----Original Message-----
> From: Gerhardus Geldenhuis [mailto:flooder@...]
> Sent: Wednesday, September 19, 2001 3:26 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Field Properties:Display Format
>
>
> Hi
> I can't seem to get my field to display a currency value(double precision)
> in the right format.
> I use %m for display format which I set up in the field
> properties tab when
> double clicking on ib_query.
> I have also edited the column attribs and checked the currency flag.
> It keeps displaying %d or %m or %8.2m no matter what I put in. Unless I
> understand format strings wrongly I dont know what else I should
> be doing to
> get the value to display R5.00 or $5.00 or any other currency.
>
> Groete
> Gerhardus
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>