Anything happen if you change the color scheme on the textbox background and the font color?
Are those boxes unbound? Not sure if that makes any difference, I would have to test.
Can you post a demo?
Thank you for replying!
Nothing happens when I change the colour scheme etc, and all the boxes are unbound. In my code I tell the boxes to have text in them depending on if conditions.
A snippet of my code can be seen below:
If (rs70.Fields(3).Value = rs74.Fields(0) Or rs70.Fields(3).Value = rs74.Fields(1) Or rs70.Fields(3).Value = rs74.Fields(2) Or rs70.Fields(3).Value = rs74.Fields(3) Or rs70.Fields(3).Value = rs74.Fields(4) Or rs70.Fields(3).Value = rs74.Fields(5)) And (rs69.Fields(2) = "Submitted evidence") Then
good5 = good5 & rs82.Fields(2) + vbCrLf
g43 = rs84.Fields(2)
Else
weak5 = weak5 & rs83.Fields(2) + vbCrLf
End If
Reports!Feedbacksheet_Q20!SR_Feedbacksheet_Q8![Q5_task1good] = good5
Reports!Feedbacksheet_Q20!SR_Feedbacksheet_Q8![Q5_task1weak] = weak5
With the text box being called Q5_task1good and Q5_task1weak - in the picture Q5_task1good was equal to "" therefore it was empty.
I don't think I would be able to post a demo as it takes it requires me to import various custom excel files however, the action is that I press a button once the database is filled with the excel files, and the textboxs which are in the subreport (SR_Feedbacksheet_Q8 should be displayed in the main report (Feedbacksheet_Q20).
The code starts with
DoCmd.OpenReport "Feedbacksheet_Q20", acViewPreview, "", "", , acHidden
Which displays the report in print preview and print preview shows that the text boxes in the subreport are populated, however, when I save them as a PDF or print them, only the textboxes in the main report are populated and the textbox in the subreport is left blank.
I could send my code if that would help?