Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / August 2004

Tip: Looking for answers? Try searching our database.

Field Formatting (Eric Butts)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jaye - 16 Aug 2004 10:48 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.