Value of a field changing to #NAME when you hit the print button.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data base on Access 2000. The data appears in in one particular
field as it should. When you hit the print button the preview comes up but
the data in that field has changed to #NAME. The data in that field is one
character and as far as I can tell it set to one character in width.
 
Are you previewing a table, form, report, or query?

If a table, is it a Memo data type field?

If a form, report, or query, is there any code behind that particular field?
You'll need to go into design mode to see.
 
When I view this as a report the correct information is the field. However as
soon as I hit print that field changes to #name. Now the field is the name of
a machine, each machine is one character ie...A, B, C and so on. The field is
10 characters in size to give it plent of room in case the machine names ever
get to be more than one letter.
 
You must log in or register to reply here.

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

Access Access Report Works on One Machine but not Another 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Print files stored in OLE fields 2
Field Value based on highest value 3
Appending records to new table using field names as values 2
Null fields on report 3
Edited data record to be inserted as a new data record under the same PO number in Microsoft Access 0
Pulling the town out of an address 5

Back
Top