2
Contributors
6
Replies
7
Views
9 Years
Discussion Span
Last Post by pranavdv
Featured Replies
  • 1

    Check for both... If InStr(Email$, "@") > 0 AND InStr(Email$, ".") > 0 Then 'Valid Email Format else 'not valid end if Read More

0

Why not use InStr?

If InStr(Email$, "@") > 0 Then 'Valid Email Format

If UCase$(Left$(Website$, 4))="WWW." then 'valid web format

If UCase$(Left$(Website$, 11))="HTTP://WWW." then 'valid web format

0

thnx for reply.

suppose some one enter "abcd@abcd"
without entering ".com / .org / .net" then how to validate?

0

Well, you'll have to check for thsoe as well. But what's to prevent someone from entering "no@way.com" as a bogus address? There's really no way to validate legitimate addresses. I would check for the presence of an @ sign and a period in the input, and assume they typed a legitimate address.

0

that is ok. but,
if some does not enter .(dot) and rest part. i.e. "no@" insted of no@way.com
then how to validate? that is my problem

and by the way for @, InStr working properly

1

Check for both...

If InStr(Email$, "@") > 0 AND InStr(Email$, ".") > 0 Then
'Valid Email Format
else 'not valid
end if

Comments
helpful person upto the last query
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.