Board index MS SQL Server

Unable to format Decimals in XP

Unable to format Decimals in XP

Post by J. Cla » Sat, 02 Nov 2002 03:24:44



I have an application that I am in the process of converting from Access 2k
to XP.  It is on an SQL 2k Database.  Anytime there is a decimal type in
SQL, I am unable to override with formatting on forms or reports.  If I set
a control to standard, general or fixed format with 0 decimal places, it
still shows the decimals that are defined in SQL.

Any ideas/suggestions???

Thanks in advance,
J. Clay

 
 
 
Top

Unable to format Decimals in XP

Post by J. Cla » Sat, 02 Nov 2002 04:44:24


I just discovered that it also is happenning on a report control using a
currancy format.


Quote:> I have an application that I am in the process of converting from Access
2k
> to XP.  It is on an SQL 2k Database.  Anytime there is a decimal type in
> SQL, I am unable to override with formatting on forms or reports.  If I
set
> a control to standard, general or fixed format with 0 decimal places, it
> still shows the decimals that are defined in SQL.

> Any ideas/suggestions???

> Thanks in advance,
> J. Clay


 
 
 
Top

Unable to format Decimals in XP

Post by Jay Shresth » Sat, 02 Nov 2002 05:23:39


We found this problem as well in Access 2002 (XP) and reported to MS.
Nothing came out of it! The problem we had was limited to fields based on
some calculation of decimal types like sum() or multiplication. Since all
these cases resulted in read-only data that we used for reporting, we ended
up casting those values as float. It was a lot of work though!


Quote:> I have an application that I am in the process of converting from Access
2k
> to XP.  It is on an SQL 2k Database.  Anytime there is a decimal type in
> SQL, I am unable to override with formatting on forms or reports.  If I
set
> a control to standard, general or fixed format with 0 decimal places, it
> still shows the decimals that are defined in SQL.

> Any ideas/suggestions???

> Thanks in advance,
> J. Clay

 
 
 
Top

Unable to format Decimals in XP

Post by Ananda Si » Sat, 02 Nov 2002 09:03:06


Hi,

Since the report is readonly can't you use

=Format(fld,"$0.00")

rather than

using

fld

as the control source and setting the format in the control's property
dialog?

HTH
Ananda


Quote:> I just discovered that it also is happenning on a report control using a
> currancy format.

 
 
 
Top

1. Informix SQL 4.1 database format (decimal format)

Hi all,

I've been asked to convert Informix SQL 4.1 database to some more useful
format. The problem is that there is really no information for
this ancient beast. I've been able to figure out all of the
field positions and what they are except for two types of fields:

decimal(12) which is stored as a 10 byte sequence (docs say 8 but it's
10).

decimal(5), etc.. which are stored as 4 byte sequence.

Yes, this is directly from the database files. Anyway, does
anyone know of how these are stored in the database?

For example, this is a sample decimal(12)

C7 14 00 04 1c 0d 38 17 00 00

And helpful information out there?

Thanks,
Adam

2. SQL Server & NT Security Groups

3. Unable to BCP Copy Data with Decimal Point

4. SE-Connect Problem

5. unable to run Progress (9.1c) Explorer tool on Windows XP

6. How can send a file to database

7. Formatting a decimal value

8. Urgent Help if possible.... cannot connect to db SQL0290N

9. Decimal format in ACE report

10. BTrieve Decimal - BCD format in VB

11. creating a view with a decimal format

12. Convert IBM Zoned-Decimal EBCDIC data to NUMBER format

13. DECIMAL output format


All times are UTC
Board index