DataGridView is bound to the SQL dataset.
The values in the SQL are decimal(18,2).
The format for the columns in the datagridview
are set to C2.
But....
   a value 77.59 displays in the grid as 78.00
   a value 44.49 displays in the grid as 44.00
The cents are rounding to whole dollars.

I also tried using an N2 format and $#,##0.00
They all gave the same results: rounding off the cents
to whole dollars.

This is not a good thing in a banking application.
:(

Somewhere in your path for the data between the DB and the screen the values are being held as integers.
(You probably already know that.)

I would investigate the logic, the scheme, the philosophy of each link in the chain. For instance, when data are imported into Access from Oracle, the field types are often misrepresented (number fields become text fields, eg).
There might be some interface (DB to network, network to datagrid, whatever) that does not understand the data type, and so is "punting," causing a rounding to be needed.

Not a very specific post, I know. Sorry about that. It's hard to formulate a guess without more specifics, but I hope this nonetheless helps.

Thank You Brian,
You are right about the chain of field definitions. I was looking for it, just could not find it.
The datagrid was set up and bound to my database when the database definition for these numeric fields was integer. I changed the database definition of the fields to be decimal(18,2) and reloaded the data into the database. What I did not know was that the DataTableAdapter? did not get the updated numeric field definitions. It was stuck on the old format. I did not know.

I finally gave up and started over with a new project and the rounding problem disappeared. Then I discovered the editor? that let me change the numeric definitions in the DataTableAdapter? to decimal. Oh happy day!!!!!
Now it works as it should. Why are these tools so darn obscure. I spent weeks looking for a way to edit those field definitions.

Thanks again,

TomH