leading and trailing space

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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?
 
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 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)

Ken Snell said:
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>

Sandy said:
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!
Click to expand...
Click to expand...
 
Sorry wasn't aware that they went to the same board. SORRY

Rick B said:
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


Sandy said:
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!
Click to expand...
Click to expand...
 
Back
Top