DBGrid display currency values

[MLNorton]

I have an Access database displayed in a DBGrid. The Access file has two currency fields that display as $xx.xx in Access but only display as xx in the DBGrid. How can I get these currency values to display as $xx.xx in the DBGrid?

 

[imex]

Try to double-click on the DataSet component of your table to open the Fields Editor window, select the field, open the Object Inspector (F11) and set the Currency property to true.

I hope this helps.


Imoveis comerciais em Guarulhos

 

[MLNorton]

I do not see a Currency property in the ADOTable or in the DBGrid columns listing.

 

[imex]

Try to double-click on the ADOTable to open the Fields Editor window.
If the window is empty, right click on the window, and then click "Add all fields".
Select the currency field, open the Object Inspector (F11) and set the Currency property to true.

I hope this helps.


Imoveis comerciais em Guarulhos

 

[DjangMan]

You can force the display format of a field after you open the table:

TFloatField(YourTable.FieldByName('YourField').DisplayFormat := '0.00';

 

[MLNorton]

Problem solved. Thanks for all of your help.