|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 26th, 2007, 07:11 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Upper Case
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 
|
|
#2
June 26th, 2007, 09:30 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Upper Case
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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#3
June 26th, 2007, 09:58 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Upper Case
So in tables design view I can force all capitals or all lower but not the
first letter of each word? "fredg" wrote: 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#4
June 26th, 2007, 10:01 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Upper Case on second thought
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? "fredg" wrote: 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#5
June 27th, 2007, 12:16 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Upper Case
On Tue, 26 Jun 2007 13:58:01 -0700, sierralightfoot wrote:
So in tables design view I can force all capitals or all lower but not the first letter of each word? "fredg" wrote: 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail You got it! However, you should NEVER enter data directly into a table anyway. Always use a form. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#6
June 27th, 2007, 12:31 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Upper Case on second thought
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 "sierralightfoot" wrote in message ... 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? "fredg" wrote: 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#7
June 27th, 2007, 12:56 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Upper Case
All entries are from a linked table.
"fredg" wrote: On Tue, 26 Jun 2007 13:58:01 -0700, sierralightfoot wrote: So in tables design view I can force all capitals or all lower but not the first letter of each word? "fredg" wrote: 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail You got it! However, you should NEVER enter data directly into a table anyway. Always use a form. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#8
June 27th, 2007, 08:55 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Upper Case on second thought
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". "sierralightfoot" wrote in message ... 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? "fredg" wrote: 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#9
June 28th, 2007, 04:14 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Upper Case on second thought
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 "Jeff Boyce" wrote: 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 "sierralightfoot" wrote in message ... 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? "fredg" wrote: 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
