Trim function returns #Type! error on text field

[SGTSweety]

I am attempting to build a Report which is a letter to program participatns. In building the address block, I want to trim the [own_city] or city. The data through a query from a linked table. The [own_city] field is 30 characters long and fills unused characters with spaces. The following in the report DATA; Control Source field returns #Type! error: =Trim ([own_city]).

Attempted to use same trim function in the query which returned negative results.

 

[Andrzejek]

Is it possibile your [tt]own_city[/tt] field contains NULL?

Have fun.

---- Andy

 

[SGTSweety]

Thanks for the quick response.

Not in this case, this field will always have a value.
I was wondering if the data from the linked table (which I cannot edit) is a factor.
Steven

 

[PHV]

What about this ControlSource ?
=Trim([own_city] & "")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SGTSweety]

PHV:

Unfortunately this didn't work either. I've never had this problem before.

Thanks for you assistance. If you think of anything else, would you mind posting it?

Steven
Have a great day.

 

[dhookom]

Make sure the name of the control is not "own_city".

Duane
Hook'D on Access
MS Access MVP