S
sturose2000
Using Access 2002, I have made a table, one field of which is Email Address.
I have set the Data Type for this field as Hyperlink. Then while I'm
entering email addresses (whether in table or form, it makes no difference
as I see it) I'll just type [email protected]. I guess due to the field type,
Access automatically changes this to [email protected]#http://[email protected]#
which, after reading the help files, appears to be [display
as]#[hyperlink]#[subaddress or hover tip]
Ok, fine, so now what I want to do is change the "http://" in all my records
to "mailto:" In the Datasheet view of my table I choose Edit/Replace, then
deselect the "Search Fields As Formatted," then choose to Match Any Part of
Field, and try to replace as specified. When I click Find Next, it will stop
at each record. But if I click Replace or Replace All, I get a message
saying "Microsoft Access can't find the text you specified in the Find What
box."
Is there an option somewhere to change these, that I'm just not seeing? Or
should I run an Update Query? I'm a bit hesitant, as it looks like update
queries replace the entire field, not just a part of it. Any suggestions?
TIA,
Stu
I have set the Data Type for this field as Hyperlink. Then while I'm
entering email addresses (whether in table or form, it makes no difference
as I see it) I'll just type [email protected]. I guess due to the field type,
Access automatically changes this to [email protected]#http://[email protected]#
which, after reading the help files, appears to be [display
as]#[hyperlink]#[subaddress or hover tip]
Ok, fine, so now what I want to do is change the "http://" in all my records
to "mailto:" In the Datasheet view of my table I choose Edit/Replace, then
deselect the "Search Fields As Formatted," then choose to Match Any Part of
Field, and try to replace as specified. When I click Find Next, it will stop
at each record. But if I click Replace or Replace All, I get a message
saying "Microsoft Access can't find the text you specified in the Find What
box."
Is there an option somewhere to change these, that I'm just not seeing? Or
should I run an Update Query? I'm a bit hesitant, as it looks like update
queries replace the entire field, not just a part of it. Any suggestions?
TIA,
Stu