formatting: adding decimal places

[slaga9]

I have had to go back and make changes to my DB to allow databases in a field in both the table, and its form.
I have tried going into design view and changing them but even with decimal selected under field size and format, but it still goes back to 28.0 when I try to enter 28.5
any suggestions?

 

[lespaul]

what kind of field did you change it to in the table design?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[Remou]

You mention the decimal type. Have you checked the scale property? You may find Double or Currency more suitable.

 

[slaga9]

hey everyone, it works,
in the table i changed the data type to currency, and the format to fixed,
in the combo box , I changed format to fixed
it works, the zeros only show up when there is a decimal, and the dollar sign doesnt show up.
thanks
Sean