I have a data field in an Access Report. Some records have data for this field some don't. I want to display the field when it has data and suppress when null. I am not sure what formula to use.
I have a data field in an Access Report. Some records have data for this field some don't. I want to display the field when it has data and suppress when null. I am not sure what formula to use.
a null value would be the same as suppressing, you cant see either of them.
but in ON PRINT event
txtBox.visible = not IsNull(txtbox)
Hello, Thank you for your response. I do not see the on print event for that Field. this is just a sample attached.
Textbox does not have OnPrint event. Report sections have OnPrint event. Or use OnFormat event for the section the textbox is in.
But as ranman said, really doesn't make much sense to do this.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.