Decimal Point Problem

[johnsqftwr]

Hi All,

Dreamweaver CS4

Microsoft Access

ASP/Vb

I have a number field in a database formatted as Double, fixed and 1 decimal place.

Adding a record via an ASP page accepts the input correctly ie 6.2

Updating the record via another ASP page returns 62 when 6.2 is entered

The paramater for the field is:

MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 5, 1, -1, MM_IIF(Request.Form("HomeOvers"), Request.Form("HomeOvers"), null)) ' adDouble

Many thanks

[johnsqftwr]

Hi All,

Problem now resolved. Converted the field in the database from number to text and both the add record and update record behaviours work.

Then able to convert back to number for calculations etc.