Issues with changing text in access 2013 report

0
votes

I have made changes to text in a sentence in a report. The changes display correctly in Design View and also in Layout View, but when I display it in print preview the previous text is displayed, not the new amended text. If I then go back to Layout view, it now displays the original text just like print preview did. The display in Design shows the new amended text.

I am using access 2013 on a *.accdb database which I was given by the previous user. Any ideas why this is happening? I would imagine that it something to do with my print preview?

1
ms-access
No idea. Would have to review the db. If you want to provide, upload to a fileshare site such as Box.com and post link. Or use a forum that allows attachment to post. – June7

1 Answers

0
votes

Most probably there is VBA code behind the report that changes the text, e.g. in an OnFormat event that only runs in Print preview.

Open Design view, open the report's code module, and search for the text you see in Print preview.