IsEmpty / Is Null command help

[vicktown]

Hi,

I am trying to get a text box (Texst box 30)on a form to print the words "NO DATA" if a certain text feild from a record is empty.

The text box and reference field for the record are being accessed in a report's section header from a query.

I am trying to use the IsEmpty or IsNull command in the On Format Event Procedure in the reports Section Footer but am having problems. Note that the section footer is where Text box 30 is.

does any one have any ideas about how to do this?

 

[KenReay]

Hi

How about

If Len(Trim(Nz(TheColumnInQuestion,"")&"")) = 0 Then
txtBox30 = "No Data"
Else
txtBox30 = TheFieldInQuestion
End if

you would need to put a bound control for TheFieldinQuestion on the report in the same section, with visible set to false


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK