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
>ebutts@online.microsoft.com
>"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/security_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" <anonymous@discussions.microsoft.com>
>| Sender: "Jaye" <anonymous@discussions.microsoft.com>
>| Subject: Format Input
>| Date: Tue, 10 Aug 2004 03:15:13 -0700
>| Lines: 12
>| Message-ID: <33e501c47ec2$ecca4290$a501280a@phx.gbl>
>| 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
Jeff Boyce - 16 Aug 2004 11:08 GMT
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.

Signature
Good luck
Jeff Boyce
<Access MVP
Roger Carlson - 16 Aug 2004 17:47 GMT
Take a look at the sample stored here:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Proper%20Case%2
0Function%202k'

Signature
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org
> Hi Eric,
>
[quoted text clipped - 82 lines]
> >|
> >| Regards