How do I not diplay 0's in textbox?

  • Thread starter Thread starter BC
  • Start date Start date
B

BC

I have two issues:
1) I have a form that I plan to use to edit and modify a table. I
want to display zeros in some fields of my form and not in others even
though the associated table may or may not contains zeros.
2) I also want to control whether or not to display zeros on my reports.

I could not find my answer in Access 2000 help ... I was probably not
wording my questions correctly.
I assume it goes under format in properties

I would appreciate the example syntax ... I am new at this.
 
Can you give us some specific examples of what you want to do? It's not
clear to me from your post just what you want to see and when.
 
I have two issues:
1) I have a form that I plan to use to edit and modify a table. I
want to display zeros in some fields of my form and not in others even
though the associated table may or may not contains zeros.
2) I also want to control whether or not to display zeros on my reports.

I could not find my answer in Access 2000 help ... I was probably not
wording my questions correctly.
I assume it goes under format in propertie
Click to expand...

A numeric format lets you specify *four different formats*, for
positive, negative, zero and null values respectively. For instance,
you could set the Format property of a textbox to:

#.00;(-#.00);0.00;"0"

to display 3.14 for a positive number, (-2.71) for a negative, 0.00
for a real zero, and 0 for NULL. Note the quotes meaning that you want
a literal text string zero rather than using the 0 "digit" format.
 
Back
Top