I am trying to get a label maker to work for my contact list, and the wizard sets everything up nicely enough at first, but it uses a function called trim() that is supposed to take out spaces and make things fit better.

When I open the report however, a prompt comes up asking for a value for Trim. No matter what I put in there, it gives me an error and no data is placed in the report.

Shouldn't Trim be an automatic function that doesn't need a value?

Does anyone know how I can fix this?

Thanks,

-Brandon

PS: The contents of the label boxes are as such:

[=Trim([FirstName] & " " & [LastName])]
=" " <- (Blank Space)
=Trim([Address])
=Trim([City] & ", " & [StateOrProvince])
=Trim([PostalCode])
=Trim([Country])

Ok, all I have to do is remove the word 'trim' and it appears to do the trimming itself...

Silly wizard...

-Brando