remove blank spaces

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

Guest

I have a report and I want to elimiate all blank spaces in every field when
the field is longer than the data.

Please advise.

thanks
 
You would have to be more specific. If you mean you have something like...

[City ] [STATE] [ZIP]

And you want to squeeze them together, you can do so by creating ONE unbound
field and putting the source as something like...

=[City] & ", " & [State] & " " & [Zip]

If you are talking vertical spacing...

[Address1]
[Address2]
[City] [State] [Zip]

and you don't want to leave a blank line if Address2 is blank, then you
would use the "canshrink" property of the field.


Hope that helps.

Rick B
 
If you want to remove all spaces you can use a query. Here
is a previous post from Allen Browne

1. Create a query into this table.

2. Drag mytextfield into the grid.
In the Criteria row under this field, enter:
Is Not Null

3. Change it to an Update query: Update on Query menu.
Access adds an Update row to the grid.

4. In the Update row under mytextfield, enter:
Replace([mytextfield], " ", "")

Run the query. All spaces are now replaced with no
character, so there is noneed to save the query.

Or

If you want to remove the spaces at the end or begining you
can use the Trim and LTrim function

Jim
 
Back
Top