Results 1 to 2 of 2
  1. #1
    Maria Tt Guest

    Answered: Checking for text in a field

    Heyas,

    Is their a function that checks if a field has text in it - I have some fields that have jut spaces - different amount eact time - and I want to filter these fields out..

    Eg I have three different mailing address fields - if mail address 2 has only got spaces - I dont want to view that field...

    Any suggestions?
    Maria Ttoullounge
    ____________
    Database Development Officer Computer Science & Engineering
    How can I control my life, when I can't control my hair?

  2. Best Answer
    Posted by GS

    "Look at the Trim function.
    Code:
    If (Trim (mail address 2) = "", "", mail address 2)
    Glenn Schwandt"


  3. #2
    GS Guest
    Look at the Trim function.
    Code:
    If (Trim (mail address 2) = "", "", mail address 2)
    Glenn Schwandt

Posting Permissions

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