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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

amiller - 26 Jul 2007 16:24 GMT

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.

Signature

amiller

Reply to this Message

Jerry Whittle - 26 Jul 2007 17:34 GMT

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.

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

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

Reply to this Message

amiller - 30 Jul 2007 14:42 GMT

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.

Signature

amiller

> Are you previewing a table, form, report, or query?
>
[quoted text clipped - 7 lines]
> > 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.

Reply to this Message