PC Review


Reply
Thread Tools Rate Thread

how can writte only with capital letters

 
 
Pedro Lerma
Guest
Posts: n/a
 
      1st Feb 2006
Hello
I want that my access database only allow me data entries with capital
letters and if this is possible I need too that my table can convert my
lower case letters in capital letters automatically
Thanks
Pedro


 
Reply With Quote
 
 
 
 
=?Utf-8?B?UGF0?=
Guest
Posts: n/a
 
      1st Feb 2006
You would put a >in your formatting of each field.
--
Thanks, Pat


"Pedro Lerma" wrote:

> Hello
> I want that my access database only allow me data entries with capital
> letters and if this is possible I need too that my table can convert my
> lower case letters in capital letters automatically
> Thanks
> Pedro
>
>
>

 
Reply With Quote
 
=?Utf-8?B?SmVycnkgV2hpdHRsZQ==?=
Guest
Posts: n/a
 
      1st Feb 2006
What Pat said.

To convert current data, use update queries and the UCase() function.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Pedro Lerma" wrote:

> Hello
> I want that my access database only allow me data entries with capital
> letters and if this is possible I need too that my table can convert my
> lower case letters in capital letters automatically
> Thanks
> Pedro
>
>
>

 
Reply With Quote
 
Pedro Lerma
Guest
Posts: n/a
 
      1st Feb 2006
thanks

"Jerry Whittle" <(E-Mail Removed)> wrote in message
news:64A13D23-795E-4E6C-A985-(E-Mail Removed)...
> What Pat said.
>
> To convert current data, use update queries and the UCase() function.
> --
> Jerry Whittle
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
> "Pedro Lerma" wrote:
>
>> Hello
>> I want that my access database only allow me data entries with capital
>> letters and if this is possible I need too that my table can convert my
>> lower case letters in capital letters automatically
>> Thanks
>> Pedro
>>
>>
>>



 
Reply With Quote
 
Pedro Lerma
Guest
Posts: n/a
 
      1st Feb 2006
ok thanks pat
"Pat" <(E-Mail Removed)> wrote in message
news:C1BC6BF8-F78E-4ED7-810D-(E-Mail Removed)...
> You would put a >in your formatting of each field.
> --
> Thanks, Pat
>
>
> "Pedro Lerma" wrote:
>
>> Hello
>> I want that my access database only allow me data entries with capital
>> letters and if this is possible I need too that my table can convert my
>> lower case letters in capital letters automatically
>> Thanks
>> Pedro
>>
>>
>>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Turn small letters to capital letters John Spencer Microsoft Access Queries 0 9th Dec 2008 12:43 PM
Turn small letters to capital letters Dimitris Microsoft Access Queries 0 9th Dec 2008 12:21 PM
How to change from capital letters to small letters and vice versa Tobias Microsoft Word Document Management 1 3rd Dec 2007 12:39 PM
how to change small letters to capital letters =?Utf-8?B?SE9XIFRPIENIQU5HRQ==?= Microsoft Excel Misc 4 30th May 2007 01:12 AM
Word Macro: How to convert capital letters to lower case letters Leonardo Da Vinci Microsoft Word Document Management 4 8th Jun 2004 02:05 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:47 PM.