| Title: | MSACCESS |
| Moderator: | BUMP::HONER |
| Created: | Tue Dec 01 1992 |
| Last Modified: | Mon Jun 02 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1661 |
| Total number of notes: | 6339 |
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 874.1 | more info | SHOEBX::CONNER | Mon Oct 17 1994 16:59 | 21 | |
| 874.2 | REAL to SINGLE works ok | WOODBX::CONNER | Mon Oct 17 1994 21:05 | 5 | |
| 874.3 | Field Test Bug | SHOEBX::CONNER | Tue Oct 18 1994 19:17 | 5 | |
| 874.4 | BUSY::SLAB | Antisocial | Wed Feb 05 1997 20:16 | 12 | |
Not relevant to the base note, but relevant to numbers:
How do I specify the output format of a negative number in Access
V2? My report is spitting out parentheses and I'd like to show a
negative sign instead.
I looked in Table, Query and Report [field] properties but there
doesn't seem to be a place to choose this output.
Thanks for any info.
| |||||
| 874.5 | OSEC::pervy.mco.dec.com::gilbertb | cyberpaddler | Wed Feb 05 1997 21:46 | 83 | |
| 874.6 | Or look outside Access for the Windows 95 settings | NSIC00::KLERK | Thunderbirds are Go | Thu Feb 06 1997 07:38 | 7 |
If nothing is specified via Format specifications inside Access, the representation for numbers is done via the Control Panel -> International Settings definitions of Windows 3.11 or Windows 95. Theo | |||||
| 874.7 | BUSY::SLAB | Candy'O, I need you ... | Thu Feb 06 1997 19:47 | 12 | |
Well, I started by going into the control panel [NT3.51] and set-
ting international to use - instead of (. Then I went into Access
and ran the report again but nothing changed. However, I didn't
exit out of Access completely, which might have made a difference.
Then I went back into Access and selected a currency field, and lo
and behold, the exact positive;negative parameters I wanted were
right there in the Format field.
Thanks to both of you.
| |||||