Upper Case

[sierralightfoot]

In design view, in an access table, under format a text field:
What is the expression ( like ">" that forces capitalization) to forced
upper case for the first letter of each word

 

[fredg]

In design view, in an access table, under format a text field:
What is the expression ( like ">" that forces capitalization) to forced
upper case for the first letter of each word

For Just The First Letter Of Each Word?

In a table? You can't.
On a Form, using the Format property? You can't.

What you can do, on a form used for data entry, is code the control's
AfterUpdate event:
Me![ControlName] = StrConv(Me![ControlName],3)

This will change your entry to capitalize the first letter of each
word, and un-capitalize all the other letters.... which often enough
is not the correct capitalization.
John van der Meer works at IBM.
will incorrectly become
John Van Der Meer Works At Ibm.

 

[sierralightfoot]

So in tables design view I can force all capitals or all lower but not the
first letter of each word?

In design view, in an access table, under format a text field:
What is the expression ( like ">" that forces capitalization) to forced
upper case for the first letter of each word

For Just The First Letter Of Each Word?

In a table? You can't.
On a Form, using the Format property? You can't.

What you can do, on a form used for data entry, is code the control's
AfterUpdate event:
Me![ControlName] = StrConv(Me![ControlName],3)

This will change your entry to capitalize the first letter of each
word, and un-capitalize all the other letters.... which often enough
is not the correct capitalization.
John van der Meer works at IBM.
will incorrectly become
John Van Der Meer Works At Ibm.

 

[sierralightfoot]

The said table is derived from a number of append quiries. Can I force upper
case on each word by using an expression in the field when I append it?

In design view, in an access table, under format a text field:
What is the expression ( like ">" that forces capitalization) to forced
upper case for the first letter of each word

For Just The First Letter Of Each Word?

In a table? You can't.
On a Form, using the Format property? You can't.

What you can do, on a form used for data entry, is code the control's
AfterUpdate event:
Me![ControlName] = StrConv(Me![ControlName],3)

This will change your entry to capitalize the first letter of each
word, and un-capitalize all the other letters.... which often enough
is not the correct capitalization.
John van der Meer works at IBM.
will incorrectly become
John Van Der Meer Works At Ibm.

 

[fredg]

So in tables design view I can force all capitals or all lower but not the
first letter of each word?

In design view, in an access table, under format a text field:
What is the expression ( like ">" that forces capitalization) to forced
upper case for the first letter of each word

For Just The First Letter Of Each Word?

In a table? You can't.
On a Form, using the Format property? You can't.

What you can do, on a form used for data entry, is code the control's
AfterUpdate event:
Me![ControlName] = StrConv(Me![ControlName],3)

This will change your entry to capitalize the first letter of each
word, and un-capitalize all the other letters.... which often enough
is not the correct capitalization.
John van der Meer works at IBM.
will incorrectly become
John Van Der Meer Works At Ibm.

You got it!
However, you should NEVER enter data directly into a table anyway.
Always use a form.

 

[Jeff Boyce]

Pardon my intrusion...

UCase([YourField])

in a query forces all upper case.

Now, why?!

If you force an upper case, you will have a very tough time reconstructing a
proper or lower case version.

If you are trying to upper-case some text for reporting purposes (e.g., for
mailing labels), store the lower case and use the UCase() function in a
query for the report.

Regards

Jeff Boyce
Microsoft Office/Access MVP

The said table is derived from a number of append quiries. Can I force
upper
case on each word by using an expression in the field when I append it?

In design view, in an access table, under format a text field:
What is the expression ( like ">" that forces capitalization) to forced
upper case for the first letter of each word

For Just The First Letter Of Each Word?

In a table? You can't.
On a Form, using the Format property? You can't.

What you can do, on a form used for data entry, is code the control's
AfterUpdate event:
Me![ControlName] = StrConv(Me![ControlName],3)

This will change your entry to capitalize the first letter of each
word, and un-capitalize all the other letters.... which often enough
is not the correct capitalization.
John van der Meer works at IBM.
will incorrectly become
John Van Der Meer Works At Ibm.

 

[sierralightfoot]

All entries are from a linked table.

So in tables design view I can force all capitals or all lower but not the
first letter of each word?

On Tue, 26 Jun 2007 11:11:00 -0700, sierralightfoot wrote:

In design view, in an access table, under format a text field:
What is the expression ( like ">" that forces capitalization) to forced
upper case for the first letter of each word

For Just The First Letter Of Each Word?

In a table? You can't.
On a Form, using the Format property? You can't.

What you can do, on a form used for data entry, is code the control's
AfterUpdate event:
Me![ControlName] = StrConv(Me![ControlName],3)

This will change your entry to capitalize the first letter of each
word, and un-capitalize all the other letters.... which often enough
is not the correct capitalization.
John van der Meer works at IBM.
will incorrectly become
John Van Der Meer Works At Ibm.

You got it!
However, you should NEVER enter data directly into a table anyway.
Always use a form.

 

[BruceM]

If the word is in lowercase, you could do something like this in the control
source for an unbound text box, or in a calculated query field (watch for
line wrapping in the newsreader):
=IIf(Asc(Left([YourField,1)) > 96 And Asc(Left([YourField],1)) <
123,Chr(Asc(Left([YourField],1))-32) &
Right([YourField,Len([YourField)-1),[YourField])

The Asc function returns the ASCII number for a character. The Chr function
returns a character for an ASCII number. The difference in the ASCII value
between upper case and lower case letters is 32. If the first letter is
"a", the ASCII value is 97. Chr(97-32) = Chr(65), which is the upper case
"A".

The said table is derived from a number of append quiries. Can I force
upper
case on each word by using an expression in the field when I append it?

In design view, in an access table, under format a text field:
What is the expression ( like ">" that forces capitalization) to forced
upper case for the first letter of each word

For Just The First Letter Of Each Word?

In a table? You can't.
On a Form, using the Format property? You can't.

What you can do, on a form used for data entry, is code the control's
AfterUpdate event:
Me![ControlName] = StrConv(Me![ControlName],3)

This will change your entry to capitalize the first letter of each
word, and un-capitalize all the other letters.... which often enough
is not the correct capitalization.
John van der Meer works at IBM.
will incorrectly become
John Van Der Meer Works At Ibm.

 

[sierralightfoot]

I want to force upper case just for the first letter in each word. I want to
do this in either the table design/format field or in the append query. The
address information comes from a link table and unfortunately its in
capitals. I can review the information for the unusual address that might
need lower case. this

Pardon my intrusion...

UCase([YourField])

in a query forces all upper case.

Now, why?!

If you force an upper case, you will have a very tough time reconstructing a
proper or lower case version.

If you are trying to upper-case some text for reporting purposes (e.g., for
mailing labels), store the lower case and use the UCase() function in a
query for the report.

Regards

Jeff Boyce
Microsoft Office/Access MVP

The said table is derived from a number of append quiries. Can I force
upper
case on each word by using an expression in the field when I append it?

On Tue, 26 Jun 2007 11:11:00 -0700, sierralightfoot wrote:

In design view, in an access table, under format a text field:
What is the expression ( like ">" that forces capitalization) to forced
upper case for the first letter of each word

For Just The First Letter Of Each Word?

In a table? You can't.
On a Form, using the Format property? You can't.

What you can do, on a form used for data entry, is code the control's
AfterUpdate event:
Me![ControlName] = StrConv(Me![ControlName],3)

This will change your entry to capitalize the first letter of each
word, and un-capitalize all the other letters.... which often enough
is not the correct capitalization.
John van der Meer works at IBM.
will incorrectly become
John Van Der Meer Works At Ibm.