error value in the printout but not in the report

A

Associates

Hi,

I was wondering if anyone might be able to help me out with the following
problem i have.

In the Access report, i have a textbox whose control source has the
following value in it.

="Student ID: " & Forms.EditStudForm.TB_studID & " Student Name: " &
Forms.EditStudForm.TB_FirstName & " " & Forms.EditStudForm.TB_LastName

When running the report, i can see all that in the report. However, when
printing it out from a printer, it read "#Name?"

I got confused as it appears all right in the report but not in the printout.

Thank you in advance
 
A

Allen Browne

When you print the report after previewing, Access will read the values from
the form again. If it worked the first time but fails the second time,
chances are something has happened to the form in between. For example,
could the form have been closed?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Printout Question 1
Printout looks bad, empty vertical spacing between records in report 7
PLEASE HELP: Refresh columns displayed in a report from a query ou 5
Printing report in booklet format 9
Populate unbound controls on report using VBA 16
issue with reading the value in the subreport from report 2
Access Access Report Works on One Machine but not Another 3
Can't create a report from my query in Access 1

Top