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
|
|||
|
|||
Format Input
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 |
#3
|
|||
|
|||
Format Input
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 |
Change Email Format On Reply or Forward | Kevin | General Discussion | 2 | July 15th, 2004 10:47 AM |
Sending email in HTML format - problems with Text Format | Krish | General Discussion | 0 | July 14th, 2004 08:40 AM |
email format | Lloyd | General Discussion | 1 | June 16th, 2004 03:42 AM |
Format will not save! | Fred | General Discussion | 2 | June 15th, 2004 06:02 PM |