Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    3

    Unanswered: removing spaces in email address field

    I am using the following as a validation rule for an email address field

    Like "*@*.*" Or Is Null

    How do I tweak it to insure that data entry can accidentally type in spaces within the email address before, within and after?

  2. #2
    Join Date
    Oct 2002
    Posts
    3

    Correction/ Re: removing spaces in email address field

    Originally posted by VT&T
    I am using the following as a validation rule for an email address field

    Like "*@*.*" Or Is Null

    How do I tweak it to insure that data entry can accidentally type in spaces within the email address before, within and after?
    The sentence above should read

    How do I tweak it to insure that data entry can NOT accidentally type in spaces within the email address before, within and after?

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Use the Key_Down event. Set the Keycode value to 0 if a space is entered. This will prevent any spaces from being entered.

  4. #4
    Join Date
    Oct 2002
    Posts
    3
    I am new to the forum so I don't know if it is not allowed, but a thank you is in order for replying to my question.

Posting Permissions

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