If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to delete leading space in Access 2007
How do I delete leading space in Access 2007? Thanks!
|
#2
|
|||
|
|||
How to delete leading space in Access 2007
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! |
#3
|
|||
|
|||
How to delete leading space in Access 2007
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" wrote in message ... How do I delete leading space in Access 2007? Thanks! |
#4
|
|||
|
|||
How to delete leading space in Access 2007
On Wed, 24 Mar 2010 14:15:01 -0700, Amy wrote:
How do I delete leading space in Access 2007? Thanks! Leading space in... what? More info please! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|