Cannot print unbound textbox (1 Viewer)

JCRamirez

New member
Local time
Today, 14:59
Joined
Sep 15, 2020
Messages
14
I have added in my report a child form that has some unbound textbox. The child form will use the dvlook function to fill the unbound textboxes and everything works perfectly fine.
In the screen, the report shows the information and also the information is shown in the print preview, but when I print the report all the unbound textboxes appear empty.
Does someone have an idea what is happening and how can I solve it.

I attached the screenshot the textbox that are in pink and purple are the unbound textboxes.
 

Attachments

  • PrintPreview.PNG
    PrintPreview.PNG
    221.4 KB · Views: 204
  • PrintedFile.pdf
    145.7 KB · Views: 272
Last edited:

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 22:59
Joined
Oct 29, 2018
Messages
21,358
Hi. Print Preview was supposed to display what the printer output should be. Not sure why you're getting a different result. We may have to see it to find out why.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 13:59
Joined
May 7, 2009
Messages
19,169
not sure but you may try using a Dummy Query as the Recordsource for the Child subform
and bind your Unbound textbox to the query's field.

your dummy recordsource:

select Top 1 dlookup("field", "table", "conditionHere") As Field1,
dlookup("field1", "table", "conditionHere") As Fiel2
from aRealTableNameHere;
 

Users who are viewing this thread

Top Bottom