Extracting text from a field's value

S

Someone

Hello

I have a text box where users can enter an email address. If possible, I'd
like to be able to extract the text following the @ symbol to use in another
control.

I've googled about with various search terms, but I'm unable to find
something to help me. Performing this sort of 'search' on a field's value
is something I haven't really tackled before, and I'd be very grateful for
some assistance.

Many thanks
M
 
J

John Vinson

Hello

I have a text box where users can enter an email address. If possible, I'd
like to be able to extract the text following the @ symbol to use in another
control.

I've googled about with various search terms, but I'm unable to find
something to help me. Performing this sort of 'search' on a field's value
is something I haven't really tackled before, and I'd be very grateful for
some assistance.

Many thanks
M
Click to expand...

Try

Mid(, InStr([email], "@") + 1)


John W. Vinson[MVP]
 
S

Someone

John Vinson said:
Hello

I have a text box where users can enter an email address. If possible,
I'd
like to be able to extract the text following the @ symbol to use in
another
control.

I've googled about with various search terms, but I'm unable to find
something to help me. Performing this sort of 'search' on a field's value
is something I haven't really tackled before, and I'd be very grateful for
some assistance.

Many thanks
M
Click to expand...

Try

Mid(, InStr([email], "@") + 1)


John W. Vinson[MVP][/QUOTE]

You're too clever :)

Thank you - your help really is appreciated.

M
Click to expand...
 
Top