Blank Space

  • Thread starter Thread starter NotGood@All
  • Start date Start date
N

NotGood@All

I have a table with a field named FirstName, all the names starts with a
blank, how do I remove the blank?
 
I have a table with a field named FirstName, all the names starts with a
blank, how do I remove the blank?
Click to expand...

You're sure it's a space and not an unprintable character?
Run an update query:

Update YourTable Set YourTable.[FirstName] = LTrim([FirstName])

Change the table name to whatever the actual name is.
 
NotGood@All said:
I have a table with a field named FirstName, all the names starts with a
blank, how do I remove the blank?
Click to expand...


Use the Trim or LTrim function.

If you want to change all the records in the table, use it
in an UPDATE query.

If users are entering the name with the extra space, add
code to the form text box's AfterUpdate event to remove the
space so you won't have the problem again..

If there are names without the extra space then it would be
best to add a WHERE clause to slelect only the records that
have the leading space:

UPDATE table Set FirstName = LTrim(FirstName)
WHERE FirstName Like " *"
 
Back
Top