Cap

  • Thread starter Thread starter ielmrani
  • Start date Start date
I

ielmrani

Hi All,
How can change the following words:

N.s.u.h. @ Plainview

To:

N.S.U.H. @ Plainview

Thanks in advance

Ismail
 
Type over it?

You could do this in code, but there are soooo many variables. Do you want
every letter preceded by a period to be capitol? Do you also want the fist
letter of each separate word to be capitalized?

What about St. Johns? Id you capitalize the letters before a period, then
the "t" would be capitalized.

What about McDaniel? If you only capitalize the first letter of each word,
then it would become "Mddaniel".

There are lots of posts out here asking to help correct capitalization. The
answer is that there are too many exceptions. Enforce it with the people
doing the data entry. Teach them to type!! :-)


If you still want to try, do a search. There are tons of posts out there
explaining the many different ways to handle this.
 
Thank you, I'll search the database for similar issues.
Ismail

Rick said:
Type over it?

You could do this in code, but there are soooo many variables. Do you want
every letter preceded by a period to be capitol? Do you also want the fist
letter of each separate word to be capitalized?

What about St. Johns? Id you capitalize the letters before a period, then
the "t" would be capitalized.

What about McDaniel? If you only capitalize the first letter of each word,
then it would become "Mddaniel".

There are lots of posts out here asking to help correct capitalization. The
answer is that there are too many exceptions. Enforce it with the people
doing the data entry. Teach them to type!! :-)

If you still want to try, do a search. There are tons of posts out there
explaining the many different ways to handle this.
Hi All,
How can change the following words:
Click to expand...
[quoted text clipped - 8 lines]
Ismail
Click to expand...
Click to expand...
 
If, that is the only item you want changed, and not every entry in the field,
you can easily change the past record by doing a simple replace. Edit>Replace
while you have the table open

ielmrani via AccessMonster.com said:
Thank you, I'll search the database for similar issues.
Ismail

Rick said:
Type over it?

You could do this in code, but there are soooo many variables. Do you want
every letter preceded by a period to be capitol? Do you also want the fist
letter of each separate word to be capitalized?

What about St. Johns? Id you capitalize the letters before a period, then
the "t" would be capitalized.

What about McDaniel? If you only capitalize the first letter of each word,
then it would become "Mddaniel".

There are lots of posts out here asking to help correct capitalization. The
answer is that there are too many exceptions. Enforce it with the people
doing the data entry. Teach them to type!! :-)

If you still want to try, do a search. There are tons of posts out there
explaining the many different ways to handle this.
Hi All,
How can change the following words:
Click to expand...
[quoted text clipped - 8 lines]
Ismail
Click to expand...
Click to expand...
Click to expand...
 
Back
Top