By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,304 Members | 1,739 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,304 IT Pros & Developers. It's quick & easy.

I do not want first caracter capitalized, how?

P: n/a
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.

Feb 19 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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" <ba***********@gmail.com> kirjoitti
viestissä:11*********************@g43g2000cwa.goog legroups.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.

Feb 19 '06 #2

P: n/a
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

Feb 19 '06 #3

P: n/a
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.

Feb 19 '06 #4

P: n/a
On 18 Feb 2006 23:34:08 -0800, "AA Arens" <ba***********@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


Feb 19 '06 #5

P: n/a
Tom van Stiphout wrote:
On 18 Feb 2006 23:34:08 -0800, "AA Arens" <ba***********@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.


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


Feb 19 '06 #6

P: n/a
On 18 Feb 2006 19:54:55 -0800, "AA Arens" <ba***********@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\(General Tab) make sure ALL options under Name AutoCorrect
are turned OFF.
Wayne Gillespie
Gosford NSW Australia
Feb 19 '06 #7

P: n/a
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" <ba***********@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\(General Tab) make sure ALL options under Name AutoCorrect
are turned OFF.
Wayne Gillespie
Gosford NSW Australia


Feb 20 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.