Mailing Labels

R

rosa5845

Hello,

I'm using Access for a membership database but when I try to preview my
mailing labels it asks me for a TRIM what is this?
 
J

Jeff Boyce

Open the report definition in design view.

Find the control on the report that includes the Trim() function. What
happens if you remove that function?

There's a possibility that your database has lost a reference ... if so,
you'll need to open a module, open the reference, and re-connect.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
K

KARL DEWEY

Somewhere along the way you must have enclosed 'TRIM' in brackets and it sees
that as a variable that needs to be satisfied.
 
R

rosa5845

How would I do this?

Jeff Boyce said:
Open the report definition in design view.

Find the control on the report that includes the Trim() function. What
happens if you remove that function?

There's a possibility that your database has lost a reference ... if so,
you'll need to open a module, open the reference, and re-connect.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.




.
Click to expand...
 
J

Jeff Boyce

....do which ...? I offered more than one possibility...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro function in Word 2
Trying to create custom labels from an csv file + Need items numerically counted out 0
After renewing my subscription my family members get a renewal message 0
cannot find which label format i need 1
Mail merge labels 8 per page, but 84 is not divisible by 8 3
TRIM function not working - even using the label wizard! 2
I can create Publisher documents, but I can not open / read them. 0
Mail Merge Help 1

Top