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
|
|||
|
|||
Field Formatting (Eric Butts)
Hi Eric,
Mant thanks for that tip. However I have more than one word in the field ie An address field could have something like New Gate Street in which case I need to force the first letter of each new word within the field to be uppercase. Is this possible? Regards Jaye -----Original Message----- Hi Jaye, For the Input Mask use: L?????????????? For details see the help topic "Input mask syntax and examples" I hope this helps! If you have additional questions on this topic, please respond back to this posting. Regards, Eric Butts Microsoft Access Support "Microsoft Security Announcement: Have you installed the patch for Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises you to review the information at the following link regarding Microsoft Security Bulletin MS03-026 http://www.microsoft.com/security/se..._bulletins/ms0 3-026.asp and/or to visit Windows Update at http://windowsupdate.microsoft.com/ to install the patch. Running the SCAN program from the Windows Update site will help to insure you are current with all security patches, not just MS03-026." This posting is provided "AS IS" with no warranties, and confers no rights -------------------- | Content-Class: urn:content-classes:message | From: "Jaye" | Sender: "Jaye" | Subject: Format Input | Date: Tue, 10 Aug 2004 03:15:13 -0700 | Lines: 12 | Message-ID: | MIME-Version: 1.0 | Content-Type: text/plain; | charset="iso-8859-1" | Content-Transfer-Encoding: 7bit | X-Newsreader: Microsoft CDO for Windows 2000 | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 | Thread-Index: AcR+wuzKDzP75HCNRdyukM3XVCh/6Q== | Newsgroups: microsoft.public.access.tablesdbdesign | Path: cpmsftngxa06.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:82603 | NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165 | X-Tomcat-NG: microsoft.public.access.tablesdbdesign | | Hi, | | I have a database that is shared by multi users. Is | there any way that I can format the inputting of data so | that it is uniformed i.e. All words start with an UPPER | CASE and then subsequent characters are lower case. | | Field Name [contact] Data Jaye Barry | | Any help would be very much appreciated | | Regards |
#2
|
|||
|
|||
Jaye
Check VBA HELP on "StrConv", using vbProperCase. Caution: McDonald, OBrien and vanDamme are also affected by use of Proper Case, and become Mcdonald, Obrien and Vandamme. Consider checking the mvps.org website for a parsing routine. -- Good luck Jeff Boyce Access MVP |
#3
|
|||
|
|||
Take a look at the sample stored he
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Proper%20Case%20Func tion%202k' -- --Roger Carlson www.rogersaccesslibrary.com Reply to: Roger dot Carlson at Spectrum-Health dot Org "Jaye" wrote in message ... Hi Eric, Mant thanks for that tip. However I have more than one word in the field ie An address field could have something like New Gate Street in which case I need to force the first letter of each new word within the field to be uppercase. Is this possible? Regards Jaye -----Original Message----- Hi Jaye, For the Input Mask use: L?????????????? For details see the help topic "Input mask syntax and examples" I hope this helps! If you have additional questions on this topic, please respond back to this posting. Regards, Eric Butts Microsoft Access Support "Microsoft Security Announcement: Have you installed the patch for Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises you to review the information at the following link regarding Microsoft Security Bulletin MS03-026 http://www.microsoft.com/security/se..._bulletins/ms0 3-026.asp and/or to visit Windows Update at http://windowsupdate.microsoft.com/ to install the patch. Running the SCAN program from the Windows Update site will help to insure you are current with all security patches, not just MS03-026." This posting is provided "AS IS" with no warranties, and confers no rights -------------------- | Content-Class: urn:content-classes:message | From: "Jaye" | Sender: "Jaye" | Subject: Format Input | Date: Tue, 10 Aug 2004 03:15:13 -0700 | Lines: 12 | Message-ID: | MIME-Version: 1.0 | Content-Type: text/plain; | charset="iso-8859-1" | Content-Transfer-Encoding: 7bit | X-Newsreader: Microsoft CDO for Windows 2000 | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 | Thread-Index: AcR+wuzKDzP75HCNRdyukM3XVCh/6Q== | Newsgroups: microsoft.public.access.tablesdbdesign | Path: cpmsftngxa06.phx.gbl | Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:82603 | NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165 | X-Tomcat-NG: microsoft.public.access.tablesdbdesign | | Hi, | | I have a database that is shared by multi users. Is | there any way that I can format the inputting of data so | that it is uniformed i.e. All words start with an UPPER | CASE and then subsequent characters are lower case. | | Field Name [contact] Data Jaye Barry | | Any help would be very much appreciated | | Regards |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
adding a field causes 90% of report to go away | cmpgeek | Setting Up & Running Reports | 6 | June 10th, 2004 08:47 PM |
REF Field Formatting not working | Amy Davis | Mailmerge | 1 | June 4th, 2004 08:41 PM |
Merge field formatting | Art Academy | General Discussion | 2 | June 4th, 2004 07:48 AM |
Make a field lookup dependent on the value in another field of a record? | Susan A | Database Design | 8 | May 22nd, 2004 09:10 PM |
Problems with InsertText field and formatting | jill | Mailmerge | 1 | May 20th, 2004 11:06 PM |