Re: Currency Fields In Dynamic ADO Queries


"eddela" <llcrcaero@xxxxxxxxx> wrote

... currency field(Cost) is displayed in the DBGrid,
in the BCD format, instead of currency. ...

What do you mean by "displayed in the BCD format"?
What is that?
I have never before heard of "BCD format" display.

BCD is the "Binary Coded Decimal" format which displays as
a Float with no $ in front of it. So, instead of the currency value
of $10.00, the BCD format is 10.00.

So specify the format you want in the field's DisplayFormat.
MyTableMyField.DisplayFormat := '$#0.00';

This is an excerpt from the Delphi online help for
"TBCDField.TBCDField converts the data from a BCD value
to a Currency value when it fetches the data from the database
table, and converts it from a Currency value to a binary-coded
decimal value when it posts the data."

True, but this does not pertain to display format. Rgds, JohnH


.

Relevant Pages

  • Re: How to convert text to number in a query?
    ... CCurconverts the value into Currency type data. ... Queries are reallly just the engine, and not really a display interface. ... on your form/report has a Format property. ... The fields in a query do have a Format property too. ...
    (microsoft.public.access.queries)
  • RE: Regional Settings Customise
    ... To Change the Date Display ... To Change the Currency Value Display ... If you do not see the format you want in the Short date or Long date boxes, ... To display single-digit numbers without a leading zero, ...
    (microsoft.public.windowsxp.customize)
  • document.write and problems with how it overwrites existing code
    ... I have a webpage that is comprised of many forms containing questions. ... when I try to get the count to display using ... FORM AND ONLY THE AMOUNT SHOWS. ... At the end you will find out the amount of currency in ...
    (comp.lang.javascript)
  • RE: Create Query to display three fields for every record in a table.
    ... You are asking how to display a currency value but don't seem to have any ... query to display Job ID, Customer ID, and deposit amount fields for every ...
    (microsoft.public.access.queries)
  • Re: OR formula error
    ... If column H is currency, why do you have Text in H3? ... If so, return zero in H3 and format it to display $-, ... Prev by Date: ...
    (microsoft.public.excel)