Binding data textbox format

• • Reply

  19 years ago

  by kyledunn

  Kyle Dunn

  , United States

  Joined 19 years ago

  I'm binding a textbox to a Currency data type in a Microsoft Access database.  Everything works as expected except for the format of the currency field in the text box.  I want to display 2 decimal places like #.##.  No matter what I enter or routines I add will work to append .00 to the text box string when the value is even dollars.  The binding seems to strip away any zeros.  10.10 becomes 10.1, 20.00 becomes 20.  Any ideas how I can solve this?

  Report abuse