Parsing Titles

  • Thread starter Thread starter Rodtnick
  • Start date Start date
R

Rodtnick

I came across Microsoft's Article Q148463 "Parsing Titles Beginning with
"A," "An," or "The"":
http://support.microsoft.com/kb/q154600/

But I don't know how to use it. The field that I want to change is
called SeriesTitle and it's the Control Source to txtSeriesTitle on the
form. How do I use this Function to mak eit change my table?

Bruce Rodtnick
 
Hi,
This is meant to be used in a query so you get the correct sorting on titles.
Copy the function to a standard module and call it from your query.

In the query grid add a calculated field, we'll call it sTitle:

sTitle: ParseArticle([SeriesTitle],-1)

then sort on this field

if you do not want to keep the 'A' or 'An' leave out the -1
 
Thanx. Works GREAT!

Dan said:
Hi,
This is meant to be used in a query so you get the correct sorting on titles.
Copy the function to a standard module and call it from your query.

In the query grid add a calculated field, we'll call it sTitle:

sTitle: ParseArticle([SeriesTitle],-1)

then sort on this field

if you do not want to keep the 'A' or 'An' leave out the -1

--
HTH
Dan Artuso, Access MVP

Rodtnick said:
I came across Microsoft's Article Q148463 "Parsing Titles Beginning with
"A," "An," or "The"":
http://support.microsoft.com/kb/q154600/

But I don't know how to use it. The field that I want to change is
called SeriesTitle and it's the Control Source to txtSeriesTitle on the
form. How do I use this Function to mak eit change my table?

Bruce Rodtnick
Click to expand...
Click to expand...
 
Back
Top