Microsoft Access label printing

  whynotsusan 16:36 23 Apr 05
Locked

I have an Access database of people and I want to create address labels. I can do it if I just put one field on each line, eg 'First Name' then 'Surname' etc. But if I put 'First Name' then a space then 'Surname' on one line, when I try to preview it, it asks for a 'Trim' parameter and I don't know what to is wanted. Whatever I've tried the first line comes out as 'Error' but the rest of each address is OK and they are in the right order (alphabetical on surnames, even though the surnames aren't showing up).
Can anybody help, please?

  Diemmess 16:55 23 Apr 05

I think the combined fields for first name and surname exceed the space allocated and the program is asking you to use the trim procedure (see Access Help), where you tell the program to use the first (number of characters) and ignore the rest. You can also use this method to trim all but the last (number of characters)

Long ago using Basic on a Tandy machine for addresses, I abreviated a Reverend gentleman's title to CANO when it should have been CANON. He was unforgiving!

  brambles 18:20 23 Apr 05

You could do a Mail Merge label in Word quite easily whilst still using your Access Database for the Merge document.


Brambles

  Access Moron 18:25 23 Apr 05

in the control of the first text box you need the following
=[First Name] & " " & [surname]

  whynotsusan 19:36 23 Apr 05

Replying to Access Moron, what I put in the box (via the wizard) was just what you recommend, but when I look at the design, it says "=Trim{[First Name] & " " & [surname]}. And when I try to preview it , it asks for a Trim parameter. I don't think what I'm asking for is too big for the space available, as I've used this previously with no problem. I've recently installed MS Office on this (new) computer and that's when the trouble started. The data file was imported from my old m/c.

  Access Moron 20:38 23 Apr 05

OK,
sounds like you have a missing reference.

the easiest way to sort this is to import all the objects into a new database.

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…