|
| 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
November 29th, 2005, 03:19 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
convert to title case?
Can I set an input mask or format that will convert ALL words in that field
to title case, even if there are several words? Also (but unrelated), how do I trim leading spaces from a field? Thanks. Sally T 
|
|
#2
November 29th, 2005, 04:50 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
convert to title case?
I dont know what you mean by 'title case'?
However, I suggest you refer to HELP on 'Mask' as it will answer your question. to trim left, use the LTRIM() function. There is also an RTRIM() function for trimming right and a TRIM() function for trimming both left and right. Dorian "sally t" wrote: Can I set an input mask or format that will convert ALL words in that field to title case, even if there are several words? Also (but unrelated), how do I trim leading spaces from a field? Thanks. Sally T
|
|
#3
November 29th, 2005, 06:01 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
convert to title case?
On Tue, 29 Nov 2005 07:19:08 -0800, sally t wrote:
Can I set an input mask or format that will convert ALL words in that field to title case, even if there are several words? Also (but unrelated), how do I trim leading spaces from a field? Thanks. Sally T Is This Your Idea Of Title Case? Code the AfterUpdate event of the control in the Form used for data entry: Me![ControlName] = StrConv([Controlname],3) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
|
#4
January 6th, 2006, 05:11 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
convert to title case?
Hello FredG, Yes, that's title case. Sorry, I'm not a developer, can you
give me step by step instructions - where do I write that code? Thanks. SAlly t "fredg" wrote: On Tue, 29 Nov 2005 07:19:08 -0800, sally t wrote: Can I set an input mask or format that will convert ALL words in that field to title case, even if there are several words? Also (but unrelated), how do I trim leading spaces from a field? Thanks. Sally T Is This Your Idea Of Title Case? Code the AfterUpdate event of the control in the Form used for data entry: Me![ControlName] = StrConv([Controlname],3) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| "1235" appears as "One thousand two hundred thirty five" | H. Kan | General Discussion | 11 | December 8th, 2006 07:56 PM |
| format numbers to letters | mhmaid | New Users | 1 | August 12th, 2005 01:49 AM |
| I NEED HELP with the SPELLNUMBER Function | vag | Worksheet Functions | 0 | June 21st, 2005 08:17 AM |
| CardText Field Switch | JoyceA | Mailmerge | 2 | June 18th, 2005 11:05 AM |
| PLEASE HELP with the SPELLNUMBER function | vag | Worksheet Functions | 0 | June 16th, 2005 01:33 PM |
Linear Mode
