Hello, MSA Group,
Does anyone know how to convert all UPPER CASE text to Initial Caps?
I'm familiar with ucase and lcase, but don't know of any function to
handle Initial Caps, i.e. every word between non breaking spaces are
Capitalized.
Thx,
Addio 3 13903
On 25 May 2005 14:36:34 -0700, Addio wrote: Hello, MSA Group, Does anyone know how to convert all UPPER CASE text to Initial Caps? I'm familiar with ucase and lcase, but don't know of any function to handle Initial Caps, i.e. every word between non breaking spaces are Capitalized.
Thx,
Addio
[FieldName] = StrConv([FieldName])
This will not properly capitalize words which ought to contain more
than one capital letter, i.e. McGregor, O'Brien, IBM, etc. which
become Mcgregor, O'brien, Ibm, etc.
You will need to use a table of exceptions if this is of importance to
you.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
On Wed, 25 May 2005 21:51:31 GMT, fredg wrote: On 25 May 2005 14:36:34 -0700, Addio wrote:
Hello, MSA Group, Does anyone know how to convert all UPPER CASE text to Initial Caps? I'm familiar with ucase and lcase, but don't know of any function to handle Initial Caps, i.e. every word between non breaking spaces are Capitalized.
Thx,
Addio
[FieldName] = StrConv([FieldName])
This will not properly capitalize words which ought to contain more than one capital letter, i.e. McGregor, O'Brien, IBM, etc. which become Mcgregor, O'brien, Ibm, etc.
You will need to use a table of exceptions if this is of importance to you.
Oops!
That should have been, in VBA:
[FieldName] = StrConv([FieldName],3)
Or as the control source of an unbound control:
= StrConv([FieldName],3)
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
"Addio" <gb********@lastar.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com... Hello, MSA Group, Does anyone know how to convert all UPPER CASE text to Initial Caps? I'm familiar with ucase and lcase, but don't know of any function to handle Initial Caps, i.e. every word between non breaking spaces are Capitalized.
Thx,
Addio
Try:
StrConv("HELLOOO!",vbProperCase) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mike S. Nowostawsky |
last post by:
I tried using the "toUpperCase()" property to change the value of an array
entity to uppercase BUT it tells me that the property is invalid. It seems
that an array is not considered an object when...
|
by: Tegdeep |
last post by:
Here's what I want to do:
I have a hash table which contains data associated to different keys.
The Hash keys are represented by a single character from the keyboard:
0-9, a-z, A-Z, and the...
|
by: Brad Smith |
last post by:
I'm trying to clean up strings in a web form before I plug the fields
into a database. Lots of folks like to leave caps lock key on and
yell their form entries.
I can figure out how to change...
|
by: Nelson |
last post by:
In my web form, I am converting all lower case letters to upper case when
the user types the characters in the edit boxes. I am achieving that by
injecting client side script (onkeyup event) for...
|
by: feeman |
last post by:
I can change a field to upper case by using the after event function
and the following code
Me. = UCase(Me.)
But how can you do it so that the whole form will change to Uppercase,
there are...
|
by: Tim_Mac |
last post by:
hi,
i'm referring to System.Globalization.TextInfo.ToTitleCase(string s)
and it works fine if you pass in an all lower or mixed case string.
however i am trying to make amends for data entry staff...
|
by: Matuag |
last post by:
How can I enable Caps Lock after the form or database opens?
|
by: =?Utf-8?B?cmtibmFpcg==?= |
last post by:
How can I force the users to enter characters in uppercase? I want to do this
in a TextBox control of an aspx page. Then I want the same to be moved to
inside a GridView control.
Thanks.
|
by: Michael Bell |
last post by:
Working my way through Koenig & Moo "Accelerated C++" and using
Borlang Builder 5 (but that is probably not relevant) I reached
exercise 1-1 and typed in
#include <vcl.h>
#pragma hdrstop...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |