Trim Function in Access 2000

[TJBernard]

I am not getting the results I expect in a few of my Trim function fields, yet I am getting the correct results on a few of my other Trim function fields on THE VERY SAME REPORT WITH THE SAME FORMAT.

This makes no sense, but here is what is happening:

I am combining two text fields into one field on a report. Here is the control source =Trim([BegBates] & " " & [EndBates]).

This simple, and two of the fields give me #Error all the way through the report and the other two fields give me the correct results. Nothing different between the feilds, they are both named differently, there is NO code on the report, there are no null values, and the fields are set can grow = true so that they cannot cut off.

What is going on??????

Thank you so much for your help,

T..J.

 

[pcs]

t.j.

only guessing here...

Access may be choking on the Trim function in a concatenation.

try something like:

control source =Trim([BegBates]) & " " & Trim([EndBates])


hth,
al