Prev: c ya
Next: Training DataBase
From: Amy on 24 Mar 2010 17:15
How do I delete leading space in Access 2007? Thanks!
From: Gina Whipp on 24 Mar 2010 17:31
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

"Amy" <Amy(a)discussions.microsoft.com> wrote in message
news:4309A0C3-6E60-4C93-BD65-F623E20DF892(a)microsoft.com...
How do I delete leading space in Access 2007? Thanks!

From: Daniel Pineault on 24 Mar 2010 17:31
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.



"Amy" wrote:

> How do I delete leading space in Access 2007? Thanks!
From: John W. Vinson on 24 Mar 2010 17:32
On Wed, 24 Mar 2010 14:15:01 -0700, Amy <Amy(a)discussions.microsoft.com> wrote:

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

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

John W. Vinson [MVP]
 | 
Pages: 1
Prev: c ya
Next: Training DataBase