form and report question

R

RHD3

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.
 
R

Rob Parker

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
 
Top