Base: How to Format Fields for Title Caps

Base: How to Format Fields for Title Caps

I get nothing when I select Format Text .

Thank you for your help.

Hello,

Sorry but do not understand the question. Please provide further explanation and/or sample.

I want east test field in my form (data) to auto Format the first letter of every word with a capitol letter. So it looks like this: I Live at 96 Elfin Road Apt 15A.

I’m sorry. Each text field.

Hello,

That functionality is not available within controls. It can be used on the form itself.

To do something like that within controls you would need to possibly write some macro to do it.

Thank you. Someone should make that a function available within Base.

You can create a user defined function if you use a spit database HSQL2.3+, see example
https://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=72206&p=324824&hilit=base+proper+function&sid=92f5dd36debc21878ce3dca117df9681#p324824