Format Input

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

Jaye

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
 
Hi Jaye,

For the Input Mask use:
L<??????????????
Click to expand...

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/ms03-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" <[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
|
 
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...
 
Back
Top