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

A

amiller

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.
 
J

Jerry Whittle

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.
 
A

amiller

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.
 
Top