Money Value gets truncated w/ADO - Xtreme Visual Basic Talk

05-02-2002, 12:50 AM

blabore

Regular

Join Date: Jan 2002

Location: Austin, TX

Posts: 83

Money Value gets truncated w/ADO

I have a column of type "money" in a SQL Server database table I need to use in a report. I can retrieve the value using ADO recordsets and insert it into the report (a word document) without any problems, but I have a problem with even values (such as exactly 10.00 etc.). Instead of of the recordset field returning 10.00, it returns the integer 10. Is there some SQL syntax I can add to my query to force it to display 2 decimals? Any help would be appreciated.

__________________
-Ben LaBore

05-02-2002, 07:19 AM

Thinker

Iron-Fisted Programmer

Retired Moderator
* Guru *

Join Date: Jul 2001

Location: Fayetteville Arkansas USA

Posts: 18,127

I don't believe this is possible. You need to format the value after
you retrieve it from the recordset.

__________________
Posting Guidelines

05-02-2002, 08:45 AM

Huby

Regular

Join Date: Apr 2002

Location: brussels, belgium

Posts: 69

just display all values with 2 decimals using the format statement

Code:

.Selction.Typetext Text:= Format(RecSet("Price"), "0.00")
or
.Selction.Typetext Text:= Format(RecSet("Price"), "currency")

05-02-2002, 03:22 PM

blabore

Regular

Join Date: Jan 2002

Location: Austin, TX

Posts: 83

Thanks guys for the help. I'll try to format it in Word as you suggested or use the FormatNumber function in VB.

__________________
-Ben LaBore