amateur question on Jet Database and FlexGrid.
Maybe you can consider using DBGrid instead of MSFlexGrid.
They are a bit defferend and a bit the same.
With DBGrid you can format eatch column seperate: After binding it to the
data-control right-click on the DBGrid and choose Properties.
On the property page Columns select:
for Column: Column0
DataField: Occur
NumberFormat: MM-DD-YY HH:MM
and for Column: Column1
DataField: Amount
NumberFormat: select Currency from the list.
Click Ok and run the project.
Greetings,
Johan.
| Assume I have a table with the following 2 fields:
| - Occur: date/time type field
| - Amount: Currency type field
| Now I bind a FlexGrid to a DataControl, and the DataControl to the
| Table.
|
| Is it possible for the Grid to display the Amount Column as "$1.00"
| instead of just "1".
|
| Is it possible to display the Occur Column without the seconds and in
| 24Hour instead of AM/PM. Because of the space it takes up in the grid, I
| would rather have "MM-DD-YY HH:MM" instead of "MM-DD-YY HH:MM:SS AM"
|
| Thanks for all information.
| G.Doucet
|
|
