[libreoffice-users] Re: How to format data entry in base table to UPPERCASE only

Am 13.04.2012 17:42, leon244 wrote:
> I am trying to find a way to format the text fields in my small data base to
> be uppercase only. Is there a way to do it at the table field level with the
> 'format', or can it only be done at the form level through a pattern field
> using 'X'?
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/How-to-format-data-entry-in-base-table-to-UPPERCASE-only-tp3908311p3908311.html
> Sent from the Users mailing list archive at Nabble.com.

Since 'x' and 'X' are different characters, this has nothing to do with 
"formatting".
Set the field type to VARCHAR_IGNORECASE so 'x' and 'X' are considered 
as equivalent. In queries you can use the UCASE or UPPER function in 
order to display the upper case version of the text.


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted