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: email@example.com 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