Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

formatting: adding decimal places

Status
Not open for further replies.

slaga9

Technical User
Jun 8, 2007
46
CA
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?
 
You mention the decimal type. Have you checked the scale property? You may find Double or Currency more suitable.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top