Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

money field

Posted on 1998-11-17
3
Medium Priority
?
242 Views
Last Modified: 2006-11-17
Hi,

I got some money field in my form and if I dont write anything in the field I want to be able to print my report but in the field where there is no amount enter I dont want to see the 0.00 $  I want the field to be empty in my report.

Thanks.
0
Comment
Question by:runner100
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
brewdog earned 0 total points
ID: 1968633
Put some code on the format event of your report that says:

If IsNull([Money]) Then
    [Money].visible = false
Else
    [Money].visible = true
End If

Or you can change the forecolor of the text box to white, or ...

hope one of those helps.

brewdog
0
 
LVL 1

Expert Comment

by:toys032498
ID: 1968634
You could add code in the After Update, or on the Lost Focus, or put in the report on the On Open to read:

If myfield.text = 0.00 then
myfield.text = ""
End If

You could also just change the format to read after update.
0
 
LVL 7

Expert Comment

by:Dedushka
ID: 1968635
Hi, runner100!

In the report design view set (do not select from list, just overtype) for your money field the value of format property instead default Currency format to this (or like this) format

$0.00;-$0.00;""

first part is format ($0.00) for positive values,
second (-$0.00) -for negative,
third ("" empty string) - for zero values, so $0.00 do not print.

Good luck, runner100...
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question