|
Home > Archive > MS Access database support > February 2006 > I do not want first caracter capitalized, how?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
I do not want first caracter capitalized, how?
|
|
| AA Arens 2006-02-19, 3:24 am |
| I want to fill in data in the fields and the first caracter is now
automatic capitalized, however, I do not want this as abbiviations must
be fully in capitals. How to get it?
Bart
Acc 2003.
| |
|
| Hi I didn't quite qet what you want?
All letters to be capitalized in specific field?
If so go to tables design mode, select the field in question, down in the
general part put > in Format if capitalised, < if lowercase letters...
-e-
"AA Arens" <bartvandongen@gmail.com> kirjoitti
viestissä:1140321294
.978437.21950@g43g2000cwa.googlegroups.com...
>I want to fill in data in the fields and the first caracter is now
> automatic capitalized, however, I do not want this as abbiviations must
> be fully in capitals. How to get it?
>
> Bart
> Acc 2003.
>
| |
| AA Arens 2006-02-19, 3:24 am |
| Hi Elly,
It;s indeed what I mean.
I do have data like conpany name, this must start with a capital
character as it is a name, but how about abbiviations, like BMW? I know
the area where I have to look for but cannot set the rules.
Bart
| |
|
| AA Arens wrote:
> I want to fill in data in the fields and the first caracter is now
> automatic capitalized, however, I do not want this as abbiviations must
> be fully in capitals. How to get it?
>
> Bart
> Acc 2003.
>
Check the Input mask for the form/table. See if it is formated also.
Then check the before/after update event for the field/form.
| |
| Tom van Stiphout 2006-02-19, 8:38 pm |
| On 18 Feb 2006 23:34:08 -0800, "AA Arens" <bartvandongen@gmail.com>
wrote:
That is a very difficult problem for computers to solve. How to teach
them that one string is a company name that should have only its first
letter capitalized, whereas another string is a companyname that is
really an abbreviation, and the convention is to capitalize all
characters. Then there are names with more than one capital letter,
such as MetLife Insurance.
The only solution I know of is a Dictionary approach: look up the word
in a dictionary of all words, to decide how to capitalize it.
-Tom.
>Hi Elly,
>
>It;s indeed what I mean.
>I do have data like conpany name, this must start with a capital
>character as it is a name, but how about abbiviations, like BMW? I know
>the area where I have to look for but cannot set the rules.
>
>Bart
| |
|
| Tom van Stiphout wrote:
> On 18 Feb 2006 23:34:08 -0800, "AA Arens" <bartvandongen@gmail.com>
> wrote:
>
> That is a very difficult problem for computers to solve. How to teach
> them that one string is a company name that should have only its first
> letter capitalized, whereas another string is a companyname that is
> really an abbreviation, and the convention is to capitalize all
> characters. Then there are names with more than one capital letter,
> such as MetLife Insurance.
> The only solution I know of is a Dictionary approach: look up the word
> in a dictionary of all words, to decide how to capitalize it.
>
> -Tom.
I suppose there is an afterupdate event calling StrConv() to make the
object Proper case. One could, in the AfterUpdate event of the field,
check to see if the record is new. If it is a new record then StrConv
and properize the field then set a flag. The person could then retype
the parts that need to be ucased and since the flag is set not
re-properize it.
Or, if a new record, prompt with the properized version if it does not
match what was entered. Ask if the Properized version is what is
desired and update if vbYes is pressed. I wouldn't bother asking if it
is an existing record.
>
>
>
>
>
>
| |
| Wayne Gillespie 2006-02-19, 8:38 pm |
| On 18 Feb 2006 19:54:55 -0800, "AA Arens" <bartvandongen@gmail.com> wrote:
>I want to fill in data in the fields and the first caracter is now
>automatic capitalized, however, I do not want this as abbiviations must
>be fully in capitals. How to get it?
>
>Bart
>Acc 2003.
Under Tools\Options\(Gener
al Tab) make sure ALL options under Name AutoCorrect
are turned OFF.
Wayne Gillespie
Gosford NSW Australia
| |
| AA Arens 2006-02-19, 8:38 pm |
| Well, I understand the situation. Then I just want to have all
restrictions off. I can type whatever I want. However, under
Autocorrect options, the field is still corrected to lower case while
alI toggles are off.
Bart
Wayne Gillespie wrote:
> On 18 Feb 2006 19:54:55 -0800, "AA Arens" <bartvandongen@gmail.com> wrote:
>
>
> Under Tools\Options\(Gener
al Tab) make sure ALL options under Name AutoCorrect
> are turned OFF.
>
>
> Wayne Gillespie
> Gosford NSW Australia
|
|
|
|
|