leading and trailing space

[Guest]

I need to delete the trailing space in a report after CITY (i.e. City,
State, Zip) for a report. I have tried TRIM([CITY]) but it is not working,
maybe I am putting it in the wrong place?...help!
Thanks!

 

[Ken Snell [MVP]]

Tell us where you're trying to use it. Are you sure it's a blank space, and
not a carriage return/line feed combination, that you need to delete?

 

[Rick B]

See answer in "getting started".

Please don't post duplicate questions. It means that you have multiple
people working on the same issue. If your question is answered in one
group, someone reading another group might not know it and could spend a
great deal of time researching and answering your question a second time.

Rick B

 

[Guest]

I have City, State & Zip as separate fields. I am trying to print a report
that will print the City, State, Zip as (Any City, State 00000)

Tell us where you're trying to use it. Are you sure it's a blank space, and
not a carriage return/line feed combination, that you need to delete?

--

Ken Snell
<MS ACCESS MVP>

I need to delete the trailing space in a report after CITY (i.e. City,
State, Zip) for a report. I have tried TRIM([CITY]) but it is not working,
maybe I am putting it in the wrong place?...help!
Thanks!

 

[Guest]

Sorry wasn't aware that they went to the same board. SORRY

See answer in "getting started".

Please don't post duplicate questions. It means that you have multiple
people working on the same issue. If your question is answered in one
group, someone reading another group might not know it and could spend a
great deal of time researching and answering your question a second time.

Rick B

I need to delete the trailing space in a report after CITY (i.e. City,
State, Zip) for a report. I have tried TRIM([CITY]) but it is not working,
maybe I am putting it in the wrong place?...help!
Thanks!