left justify text field

[Guest]

I am trying to remove the leading blanks in a text field. Got any good
ideas?

Thanks

 

[Brendan Reynolds]

An update query using the LTrim function ...

UPDATE YourTableNameHere SET YourFieldNameHere = LTrim([YourFieldNameHere])
WHERE YourFieldNameHere Is Not Null

 

[Guest]

Thank you. I think that I am having one of those stupid days.

An update query using the LTrim function ...

UPDATE YourTableNameHere SET YourFieldNameHere = LTrim([YourFieldNameHere])
WHERE YourFieldNameHere Is Not Null

--
Brendan Reynolds (MVP)

I am trying to remove the leading blanks in a text field. Got any good
ideas?

Thanks

 

[thcode]

OK, I figured this out but I am curious if there is an easier way and for
anyone elso who is new.

I did the query design picked my table then clicked the update for query type
then I clicked the SQL view button (lower right corner of screen) and pasted
in the code made the changes to field and table and went back to regular view
button (lower right corner of screen) and added some other fields that I also
needed to trim.

this makes more sense when you see the SQL view.

This was great.

Thank You.
Tina

An update query using the LTrim function ...

UPDATE YourTableNameHere SET YourFieldNameHere = LTrim([YourFieldNameHere])
WHERE YourFieldNameHere Is Not Null

--
Brendan Reynolds (MVP)

I am trying to remove the leading blanks in a text field. Got any good
ideas?

Thanks