form and report question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I've created a form for entering data and a report for printing the data.
It is a Purchase Order. In both my form and report I have "text boxes" that
will populate the table that each is linked to. I have some of the boxes
formatted for "numbers" and some for "currency". When I open either one I
see "0" for the number and "$0,00" for the currency. I would like to show "
"(nothing) if the box isn't filled in, but show the value if it is actually
entered. Is there a way to do this? I know I can turn off the whole thing,
but I'd like for the box to be blank unless there is something entered.
Thank you.
 
You can set up a custom format, with entries in up to four sections, to
control what is displayed for positive, negative, zero, and null values.
Check the Help file for "Format Property - Number and Currency Data Types".

HTH,

Rob
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
Problem with Report and Forms 2
Access Access Report Works on One Machine but not Another 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Need help setting up a Parent form with three subforms 8
Currency formatting (Issue with globalization/localization) 2
Hello happy new year to all, Text box input for year of purchase 0
changing multiple records with a combo box. 1

Back
Top