|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 12th, 2007, 06:43 PM
posted to microsoft.public.access.reports
|
|||
|
|||
$ needs to go away
I got a report that already has the $______
My field is currency and diplays $500.00 which is perfect except I dont need both $ signs If I dont use the field the $ still must be there for the contract to be valid so I need it changed on the control that 500.00 id transparently placed over the $_______ Thanks Dan 
|
|
#2
March 12th, 2007, 08:35 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
$ needs to go away
Then leave the literal "$" and change the formatting of the field to
numbers, instead of currency. Of, change the whole thing to be an "if" statement that will either print the value formatted as currency, or will print the literal "$ ________". -- Rick B "Dan Goble" wrote in message ... I got a report that already has the $______ My field is currency and diplays $500.00 which is perfect except I dont need both $ signs If I dont use the field the $ still must be there for the contract to be valid so I need it changed on the control that 500.00 id transparently placed over the $_______ Thanks Dan
|
|
#3
March 12th, 2007, 09:51 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
$ needs to go away
Dan Goble wrote:
I got a report that already has the $______ My field is currency and diplays $500.00 which is perfect except I dont need both $ signs If I dont use the field the $ still must be there for the contract to be valid so I need it changed on the control that 500.00 id transparently placed over the $_______ Choose something other than the Currency format. You can always use a custom format if you can't find a named format that does what you want. -- Marsh MVP [MS Access]
|
|
#4
March 12th, 2007, 10:05 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
$ needs to go away
On Mon, 12 Mar 2007 13:43:50 -0500, Dan Goble wrote:
I got a report that already has the $______ My field is currency and diplays $500.00 which is perfect except I dont need both $ signs If I dont use the field the $ still must be there for the contract to be valid so I need it changed on the control that 500.00 id transparently placed over the $_______ Thanks Dan =" I got a report that already has the $ " & Format([YourField], "#,##.##") or = "I got a ..... " & Format([Yourfield],#,#0.00") whichever suits you. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#5
March 13th, 2007, 04:35 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
$ needs to go away
Jeez,
All three suggestions work perfectly Thanks I learned a lot on this one Dan "Dan Goble" wrote in message ... I got a report that already has the $______ My field is currency and diplays $500.00 which is perfect except I dont need both $ signs If I dont use the field the $ still must be there for the contract to be valid so I need it changed on the control that 500.00 id transparently placed over the $_______ Thanks Dan
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
