Making Textbox Invisible in Report-HELP!

I created a simple Report for an invoice. How do I make a textbox invisible if the value is 0.00?

I tried a If then else statement but, obviously I'm missing something.

My textboxes are Amount1 - Amount5

Going crosseyed-- need your help!

Johanna

--
Message posted via http://www.accessmonster.com

re: Making Textbox Invisible in Report-HELP!

There are probably better ways of doing this but one method that I have
used is to have another invisible text box with the controlsource that
your current text box has. Then make the controlsource of your current
textbox: =IIf([SecondTextBox] = 0,Null,[SecondTextBox])

HTH

re: Making Textbox Invisible in Report-HELP!

On Sun, 09 Jan 2005 18:27:27 GMT, Johanna Albee via AccessMonster.com
wrote:
[color=blue]
> I created a simple Report for an invoice. How do I make a textbox invisible if the value is 0.00?
>
> I tried a If then else statement but, obviously I'm missing something.
>
> My textboxes are Amount1 - Amount5
>
> Going crosseyed-- need your help!
>
> Johanna[/color]

Invisible?
Or just not show any value?
Set the Format property of each control to:
#.00;-#00;""

In Access help, look up:
Format property + Number and currency datatypes
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

re: Making Textbox Invisible in Report-HELP!

Ok I will try that out. I don't want the text boxes to show any value if it is 0.00.

--
Message posted via http://www.accessmonster.com

re: Making Textbox Invisible in Report-HELP!

Thank you Fredg! That worked beautifully! You have ended my torture.
:)

Johanna

--
Message posted via http://www.accessmonster.com

re: Making Textbox Invisible in Report-HELP!

"Johanna Albee via AccessMonster.com" <forum@AccessMonster.com> wrote in
message news:c70f06dbfded4dfd8991cf7307201aab@AccessMonste r.com...[color=blue]
>I created a simple Report for an invoice. How do I make a textbox invisible
>if the value is 0.00?
>
> I tried a If then else statement but, obviously I'm missing something.
>
> My textboxes are Amount1 - Amount5
>
> Going crosseyed-- need your help![/color]

Your code needs to be in the OnFormat event:

if textboxdatafield = 0 then textbox.visible = true else textbox.visible =
false

(I think you can do it on one line like that.)