Help with Trim Function on a report

[Bill Johnson]

This is so strange - I have a field that has some trailing spaces. On the
report I decided to use =RTrim([FIELD]) so I could property center the field.
When I ran the report with this substituted for the field I received the
data that belongs in a different field. When I removed the RTrim function I
once again got the correct data. I also tried using =Trim([Field]) and got
the same result.

I'm using Access 2007 and saving the database for Access 2003.

Thanks for any thoughts on this?

 

[Kelly Cox]

Can you trim in the query, rather than the report? Sometimes that is more
effective, removing unexpected 'garbage'.

 

[Bill Johnson]

Kelly

Thanks. Yes I've been able to use trim in a query and that worked
perfectly. I thought it might be easier in the report. I did find what was
causing this to happen. I used the field (FUND) to copy and create another
field on the report, subsequently I used the FUND field to create another
field leaving the name of the field as (FUND). When I created another field
using =Trim([FUND]) it gave me the contents of the field with that name. I
hope I wrote that so it could be followed!

Thanks for the response

Bill

Can you trim in the query, rather than the report? Sometimes that is more
effective, removing unexpected 'garbage'.

This is so strange - I have a field that has some trailing spaces. On the
report I decided to use =RTrim([FIELD]) so I could property center the field.
When I ran the report with this substituted for the field I received the
data that belongs in a different field. When I removed the RTrim function I
once again got the correct data. I also tried using =Trim([Field]) and got
the same result.

I'm using Access 2007 and saving the database for Access 2003.

Thanks for any thoughts on this?