Prev: PLEASE HELP -- BAR CHART COLOR ....
Next: Printing on a preprinted form from multiple printers
From: Tara on 25 Mar 2010 13:14
I have a Label report that is based on a single table - tblContactInfo. I
have a strange issue happening when I run the report but it's only happening
with one record - all other labels are correct. For this one label, the
entry has an additional letter (in this case, it's a lower case s) and a
period in front of the name. For example, the labels should read:

John Smith
1234 American Way
Anytown, NY 56789

Jane Doe
5555 Red Bird Cove
Somewhere, NY 12345

And they all do, except for one. This particular label reads:

s. Mary Smith
9999 Any Street
Anycity, NY 34543

I've looked in the underlying table and the (s.) does not exist. I've even
cleared out all the fields and ran the report again. The (s.) still shows
up!

Could this be a sign of corruption??

Any advice is appreciated...

From: Tara on 25 Mar 2010 13:56
I'm not sure what was causing it, but I needed to run these lables, so I just
deleted the entire record and re-entered it. It's fine now. I'm still
curious as to what the issue was though...


From: HC on 25 Mar 2010 13:58
On Mar 25, 1:14 pm, Tara <T...(a)discussions.microsoft.com> wrote:
> I have a Label report that is based on a single table - tblContactInfo.  I
> have a strange issue happening when I run the report but it's only happening
> with one record - all other labels are correct.  For this one label, the
> entry has an additional letter (in this case, it's a lower case s) and a
> period in front of the name.  For example, the labels should read:
>
> John Smith
> 1234 American Way
> Anytown, NY 56789
>
> Jane Doe
> 5555 Red Bird Cove
Did you open the table and check on the field value? s. mary is may
be a field value.

GL


> Somewhere, NY 12345
>
> And they all do, except for one.  This particular label reads:
>
> s. Mary Smith
> 9999 Any Street
> Anycity, NY 34543
>
> I've looked in the underlying table and the (s.) does not exist.  I've even
> cleared out all the fields and ran the report again.  The (s.) still shows
> up!  
>
> Could this be a sign of corruption??
>
> Any advice is appreciated...

 | 
Pages: 1
Prev: PLEASE HELP -- BAR CHART COLOR ....
Next: Printing on a preprinted form from multiple printers