Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    41

    Unanswered: Trimming whitespace in text fields

    How do you trim whitespace off of the beginning and end of a text field?

  2. #2
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile Re: Trimming whitespace in text fields

    Originally posted by secutanudu
    How do you trim whitespace off of the beginning and end of a text field?
    Not sure where you're doing this but you can remove extra space from strings by using the Trim, LTrim and RTrim functions. You can use these in queries and expressions that are the control source for controls on forms and reports.
    Gregg


    DAO, ADO, SQL, Automation and anything else I can pick up.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •