How to delete leading space in Access 2007

[Amy]

How do I delete leading space in Access 2007? Thanks!

 

[Daniel Pineault]

Look at the LTrim, RTrim, and Trim Functions.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Gina Whipp]

Amy,

Ummm, a wee bit more information needed... Would that be leading spaces in
a field? OR is there a report that when printed some of the fields appear
to have leading spaces? OR do you have fields where the data, some not all,
was entered with leading spaces?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

How do I delete leading space in Access 2007? Thanks!

 

[John W. Vinson]

How do I delete leading space in Access 2007? Thanks!

Leading space in... what? More info please!