Extracting text from a field's value

[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

 

[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

Try

Mid((e-mail address removed)

 

[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

Try

Mid((e-mail address removed)