ACCESS FEED: RE: [MS_AccessPros] How do I truncate a URL

Selasa, 25 Juni 2013

RE: [MS_AccessPros] How do I truncate a URL

Robin-

If this is a Hyperlink data type, you can set the display text when you save
the hyperlink to your table.

A Hyperlink field can contain four parts, each separated with a # character:

1. Display text
2. The Hyperlink
3. A bookmark within the Hyperlink
4. Tooltip text displayed when you hover over the link

If you tab into a Hyperlink field then press F2 to go into character edit
mode, you should see a # to start the string.

Simple hyperlink:

#http://www.msdn.com/

Hyperlink with display text:

MSDN library#http://www.msdn.com

Hyperlink with bookmark:

MSDN library#http://www.msdn.com#FirstTopic

Does that help?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Wednesday, June 26, 2013 4:48 AM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] How do I truncate a URL

Yes this can be done with string/text functions like:
- Instr() to find text within a string
- Left()
- Right()
- Mid()
- InstrRev()

There are descriptions and examples in Help and all over the web.

Duane Hookom MVP
MS Access

----------------------------------------
> From: robinski@mymail.net.au
>
> I have a query that records visitors to our web pages. It includes the
> domain name for each and every line which is both very space consuming
> and very poor visually.
>
> Is there any way that I can show the URL without the domain name?
>
> Many thanks,
>
> Robin Chapple

------------------------------------

Yahoo! Groups Links