 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2007$ 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 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 "$ ________".  SignatureRick B >I got a report that already has the $______ > My field is currency and diplays $500.00 which is perfect except I dont [quoted text clipped - 5 lines] > Thanks > Dan >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. SignatureMarsh MVP [MS Access] > I got a report that already has the $______ > My field is currency and diplays $500.00 which is perfect except I dont need [quoted text clipped - 5 lines] > Thanks > Dan =" I got a report that already has the $ " & Format([YourField], "#,##.##") or = "I got a ..... " & Format([Yourfield],#,#0.00") whichever suits you. SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail Jeez, All three suggestions work perfectly Thanks I learned a lot on this one Dan >I got a report that already has the $______ > My field is currency and diplays $500.00 which is perfect except I dont [quoted text clipped - 5 lines] > Thanks > Dan |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.