# Error on Report

[zufie]

I receive the # Error when I run my Mailing Label report.

I generated the report using Label Wizard.

The # Error appears in the Name field portion of the Label.

My report is based on a query.

I checked to see if I had any Null values for the Name field.

I do NOT have any null values for the Name field.

Any ideas or suggestions?

Thanx!

I know it must be something small that I am overlooking!

Thanks again,
John

[Allen Browne]

The label wiz uses Trim(), so it can occur if there's a problem with
references in your database.

Details on what references you need in each version of Access and how to
solve problems with them:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"zufie" <jo***********@illinois.govwrote in message
news:e5**********************************@w7g2000h sa.googlegroups.com...

>I receive the # Error when I run my Mailing Label report.

I generated the report using Label Wizard.

The # Error appears in the Name field portion of the Label.

My report is based on a query.

I checked to see if I had any Null values for the Name field.

I do NOT have any null values for the Name field.

Any ideas or suggestions?

Thanx!

I know it must be something small that I am overlooking!