Field Formatting (Eric Butts)

  • Thread starter Thread starter Jaye
  • Start date Start date
J

Jaye

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:


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
(e-mail address removed)
"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
Click to expand...
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" <[email protected]>
| Sender: "Jaye" <[email protected]>
| Subject: Format Input
| Date: Tue, 10 Aug 2004 03:15:13 -0700
| Lines: 12
| Message-ID: <[email protected]>
| 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
Click to expand...
 
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.
 
Take a look at the sample stored here:

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Proper Case Function 2k'


--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Jaye said:
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:


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
(e-mail address removed)
"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
Click to expand...
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" <[email protected]>
| Sender: "Jaye" <[email protected]>
| Subject: Format Input
| Date: Tue, 10 Aug 2004 03:15:13 -0700
| Lines: 12
| Message-ID: <[email protected]>
| 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
Click to expand...
Click to expand...
 
Back
Top