jon thanks for the help but I have tried using spaces via the keyboard. This worked in Access 97 but in 2000 I get an error "enter parameter value" with a box saying "trim", ok/cancel. If I remove the spaces the error message disappears.
Can you help?


When creating labels using the label wizard how do you get a space between the fields.

eg Mr Fred Bloggs.

It does not accept spaces, so I get MrFredBloggs.

Many thanks
Dave

[This message has been edited by dafarmer (edited 11-26-2001).]

While creating your layout in the wizard, you actually have to enter a space using your space bar.

You can add text such as "Attention: " by typing it BEFORE adding the field on the left that you want to show on your report.

Jon, I have added to my original post. Are you able to offer any further help on this?

I have never used Access for labels...
However, I HAVE used WORD...
You oughta try word using a MailMerge...
Works wonders...And you can put the spaces wherever you want them...

Did you put the spaces in while using the wizard?

If not, go into design view. Edit the datasource showing in the control as such"

[FirstName] & " " & [LastName]

Leave the TRIM statement in.