How to display text boxes which are filled by user in the form to the report?

[sarkar]

Dear All,
My name is Ms. Sarkar and I am having a problem with VBA code in ms access 2010.
How to display specific text boxes which are filled by user in the form to the report?
i would like to display in the report only text boxes which are filled in the form by the user and not to display empty textboxes.

Thanks and kindly please assist.

 

[Ranman256]

you are creating a lot of unnecessary work, when you can just show the form,then print.

If you know vba, then in the ON PRINT event of the report,
txtBox.visible = not IsNull(txtBox.value)
for every box

 

[sarkar]

Hello Ranman256,
Thanks a lot. I really appreciate it. It worked. Thank you very much.