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+h...@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
