Blank report textboxes

[Peps]

Hi, I'm afraid that I've got another question:

Is there any way I can create a report that can show or hide the document data as shown below:

I have a TextBox with then below Control Source:
="Doc. Number:"+[Doc]

The idea is that when [Doc] TextBox (which is not visible) has a null value or 0, no data is shown. The problem is that [Doc] is a Number field and I always get "Doc. Number:" when there is not data to be shown.

I can use Label that shows Doc. Number and then the DocTextBox but then we are back to square 1.

I tried to the Me.Visible function but it's not working.

Any ideas,
Thanks.

 

[dhookom]

Try:
=IIf(Nz([Doc],0)=0,Null,"Doc. Number:")

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Peps]

Thank you, the IIf cmd did not even cross my mind.

Cheers mate,