SQL Database column has 2 decimals - Textbox displays 4????

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi All;

I have created a MSDE SQL table with a column set to money, format is
standard with 2 decimal places. Into the field I put 12345.67. When
you view the data it shows 12,345.67. When I run the form, fill the
dataset the Textbox shows 12,345.6700.

Do I need to reformat the Textbox after the fill to only show 2
decimal places? If so is there a global setting that can do this or do
I need to do this on all Textbox controls that contain numbers?

Thanks.
 
Back
Top