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])
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])
