Strange Label issue

[Tara]

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

 

[Tara]

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

 

[HC]

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