A real easy one I think??*12809

[Earl.AKA J.Alladien in access forum!!]

Hi all ,

I have following e-mail adresses in my table as follows:

E-mail: (e-mail address removed)
E-mail: (e-mail address removed)
E-mail: (e-mail address removed)

and I would like them to display like:

(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

Without the "E-mail:"

Thanks in advance!!!

 

[Danny Lesandrini]

Display where? In a report?

If the text "E-mail: " doesn't belong, why not just strip it out with an UPDATE query?

For a report, you can dynamically strip it by using one of these functions ...

ControlSource of text box = Replace(,"E-mail: ","")
or
ControlSource of text box = Mid([Email], 9)

 

[Mike]

Display in what , a form, a report, in another table?

More info please.

 

[Earl.AKA J.Alladien in access forum!!]

That did it,

Thanks Danny!

Display where? In a report?

If the text "E-mail: " doesn't belong, why not just strip it out with an UPDATE query?

For a report, you can dynamically strip it by using one of these functions ...

ControlSource of text box = Replace((e-mail address removed)

 

[MikeJohnB]

Surely when using mid, you have to take into account the variation in the
length of various e mail addresses as in?

Mid((e-mail address removed)

 

[Clif McIrvin]

Surely when using mid, you have to take into account the variation in
the
length of various e mail addresses as in?

Mid((e-mail address removed)

 

[MikeJohnB]

Ahhhh, I see said the Blind Man

Thanks
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B

Surely when using mid, you have to take into account the variation in
the
length of various e mail addresses as in?

Mid((e-mail address removed)

 

[Clif McIrvin]

Ahhhh, I see said the Blind Man

Thanks

You're welcome