Formating forms

[jnashmd]

Is there a way to format a field in a form in Base so that each word in the field is capitalized?

[pluby]

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.

Hope that helps.

Patrick

[jnashmd]

Patrick-

Thanks, again. That work around would be too cumbersome for my purposes.

Jim

[pluby]

[Jim]

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.