Report Textbox IIf problem

[doile]

In a report, I use a text box as a label ONLY when the field is not null. Example:

=IIf([Forms]![fSOP]![OD] Is Not Null,"Other Report Results"," &quot

This works fine when I preview it, but when I email it and view it in MSWord (richtext format) it prints the Text Box Name. This kind of defeats the purpose. Any suggestions?

 

[Darrylles]

This is confusing!
You can't have a Textbox object as a Label. A Label is a Label object, a Textbox is a Textbox object.

I assume that you mean that you 'regard' the textbox as a label if it is null.

How are you saving this report in order to email it, and can you view the saved report correctly outside of Access before emailing it?

If so, email it to me if poss. at: darrylles@totalise.co.uk. pls.

Regards,

D



"Never argue with an idiot, he'll bring you down to his level - then beat you with experience."