Access XP (2002) Error Messages

[Palani]

I have a simple one table Access XP database with FirstName, LastName,
Address, City, State and , ZipCode. I am trying to make labels, using the
Label Wizard with Avery 5160. I have been able to use this label for quite a
while. But now, for some reason when I click on the Label Names in the
Reports window I get the following message:

There is not enough horizontal space on the page for the number of colums
spacing specified. Click the Page
Setup on the File menu, click the Columns tab, and then reduce the number of
columns or the size of the
columns.

I did what it says up above but it's still not working. Then when I click on
the Label Names again I get a dialogue box. The title of the dialogue box
says Enter Parameter Value. Then underneath that it says Trim. Then it has a
field to enter a value and underneath that are two buttons, OK and Cancel.

In Design View my fields read as follows:

=Trim([FirstName] & " " & [LastName])
Address
=Trim([City] & ", " & [State] & " " & [ZipCode])

Any ideas why I'm getting this message? As I mentioned earlier. I've had no
problems in the past but somewhere, somehow someting went wrong.

Any help on this is greatly appreciated.

Thanks

 

[jatfill]

I get that message every time I use the label wizard/5160 combo. All I do to solve it is to resize/shrink the right side of the report over to the left, eliminating the right 'gap' between the end of the report and the end of the field. After that the message dissappears & they print fine.

 

[Palani]

jatfill,

Thanks for the reply. What I ended up doing was exporting the table to a new database. Made the labels and everything is working fine....

But I will keep your reply in mind incase it happens again

Palani

 

[jkolo]

Parameter asking for trim

Check your references- I had none MISSING- but I unchecked the Util box and all works fine now.

Hopefully this doesn't effect the rest of my program.