ASP, Access XP, and Decimal Places...

[natalie]

Hi forum members

Alright, I am opening an Access XP database via ASP. One of the fields is a numerical field, and I would like to force it to display the number + 1 digit to the right of the decimal. For some reason it is only displaying digits to the left.

In Design View, my Access Table (names 'arlist') looks like this:
Field Name: level, Data Type: Number, Field Size: Integer, Format: Fixed, Deciaml Places: 1

My SQL Statement: SELECT * FROM arlist;

Then the VBScript I'm using to access the table looks like this:
Response.Write"<TD align=""right"" bgcolor=""" & strBG & """ width=""10%""><P class=""body"">" & rsDC.Fields("level") & "</TD>" & vbCRLF

I am opening the table via ADO Statically with a Read-Only pointer because the page just displa -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[danielle]

You have The Field Size is set Integer. This does not allow for decimal points. Although it lets you set it.
Change it to Double or Decimal.
Also check the Help for access under the "FieldSize Property" topic. It has all the specs for the Field types and there capabilities.
This is based on my experience with Access 2000 not XP. I am not sure if there are differences.

Good luck
Bye -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --