A real easy one I think??*12809

  • Thread starter Earl.AKA J.Alladien in access forum!!
  • Start date
D

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)
 
E

Earl.AKA J.Alladien in access forum!!

That did it,

Thanks Danny!



Danny Lesandrini said:
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)

--
Danny J Lesandrini
[email protected]
www.amazecreations.com



[QUOTE="Earl.AKA J.Alladien in access forum!!"]
Hi all ,

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

E-mail: [email protected]
E-mail: [email protected]
E-mail: [email protected]

and I would like them to display like:

[email protected]
[email protected]
[email protected]

Without the "E-mail:"

Thanks in advance!!!
[/QUOTE]
[/QUOTE]
Click to expand...
 
M

MikeJohnB

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

Mid(,7,Len([Email])-6)

Will return any e mail address independant of the length

Kindest Regards

Mike B
--
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


[QUOTE="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([Email],"E-mail: ","")
or
ControlSource of text box = Mid([Email], 9)

--
Danny J Lesandrini
[email protected]
www.amazecreations.com



[QUOTE="Earl.AKA J.Alladien in access forum!!"]
Hi all ,

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

E-mail: [email protected]
E-mail: [email protected]
E-mail: [email protected]

and I would like them to display like:

[email protected]
[email protected]
[email protected]

Without the "E-mail:"

Thanks in advance!!!
[/QUOTE]
[/QUOTE]
 
C

Clif McIrvin

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

Mid(,7,Len([Email])-6)
[/QUOTE]
Nope ... the length parameter is optional and defaults to the remaining
length.

--
clif
[QUOTE]
Will return any e mail address independant of the length

Kindest Regards

Mike B
--
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


[QUOTE="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([Email],"E-mail: ","")
or
ControlSource of text box = Mid([Email], 9)

--
Danny J Lesandrini
[email protected]
www.amazecreations.com



"Earl.AKA J.Alladien in access forum!!"
[QUOTE]
Hi all ,

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

E-mail: [email protected]
E-mail: [email protected]
E-mail: [email protected]

and I would like them to display like:

[email protected]
[email protected]
[email protected]

Without the "E-mail:"

Thanks in advance!!!
[/QUOTE]
[/QUOTE][/QUOTE]
Click to expand...
 
M

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


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

Mid(,7,Len([Email])-6)
[/QUOTE]
Nope ... the length parameter is optional and defaults to the remaining
length.

--
clif
[QUOTE]
Will return any e mail address independant of the length

Kindest Regards

Mike B
--
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


[QUOTE="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([Email],"E-mail: ","")
or
ControlSource of text box = Mid([Email], 9)

--
Danny J Lesandrini
[email protected]
www.amazecreations.com



"Earl.AKA J.Alladien in access forum!!"
Hi all ,

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

E-mail: [email protected]
E-mail: [email protected]
E-mail: [email protected]

and I would like them to display like:

[email protected]
[email protected]
[email protected]

Without the "E-mail:"

Thanks in advance!!!
[/QUOTE][/QUOTE]
[/QUOTE]
Click to expand...
Click to expand...
 
Top