Unfortunately, NeoOffice's underlying OpenOffice.org 3.1.1 Base code has only a very limited amount of word processing features. You can apply a formatting code to a column in a Base table, but those formatting codes are only for numeric input and they only limit input, they don't autocorrect.
Calc, however, does have the PROPER() function. Although it is a bit of a hassle, one potential workaround is to copy text columns from your Base table (copy from the table directly, not through the form) to a Calc document. Then, add a column in the Calc document with the PROPER() function referencing each matching cell in the column that has text. You should be able to copy the cells with the PROPER() function and paste them back into your Base table.
Thanks, again. That work around would be too cumbersome for my purposes.
I suspected that it would be cumbersome. Realistically, my workaround is really only becomes efficient to use when you are try to clean up a large number of text fields that are already in a table.
Joined: Jun 21, 2003 Posts: 173 Location: Selmer, Tennessee
Posted: Tue Jun 01, 2010 6:42 am Post subject:
I assume you want to do something like this:
Change "open office base" to "Open Office Base."
AFAIK, there's no way to reformat the displayed field. But you might try looking into the SQL commands that Base understands. You'd have to change the underlying table's column using the SQL command REPLACE(), and finding the beginnings of words using the SUBSTR() and other string-handling functions. This could get pretty cumbersome and error-filled rather quickly, so work only on a copy of the database until you get the command right.
Sorry I can't be of more help, but I don't use Base very much. _________________ Jim Plante
MacOS X 10.6.34, MacBook 2GHz C2Duo, 2gb, Neo 3.1.1 p 1
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum