How do I make entry all caps

[mktork]

Is it possible to make the data entered into my forms be all capital?

[DACM]

Is it possible to make the data entered into my forms be all capital?

Edit: See Villeroy's post below... Simply use a pattern field.

It is possible, with a macro...

Code: Select all

Sub UPPER_case (oEvent As Object) 'Text Box > Events > When Losing Focus 
	oTextBox = oEvent.Source.Model
	sText = Ucase(oTextBox.Text)
	oTextBox.setString(sText) 'same effect as .BoundField.updateString() below 
'	oTextBox.BoundField.updateString(sText) 'same effect as .setString() above

'	oForm = oTextBox.Parent 'these 3 lines combined will immediately save the record...
'	oForm(oTextBox.Name).commit()
'	IF oForm.isnew THEN oForm.insertRow() ELSE oForm.updateRow()
End Sub 

[mktork]

Thank you DACM. I'm just starting to learn macros so I have a few newbie questions.
First, which language is that? JAVA?
Second,do you know any good tutorials for learning that language?

Thank you for any and all help given.

Mktork

[rudolfo]

The language that is used in the above macro is OpenOffice Basic. But actually it is not really relevant, there is only one line that is specific for Basic and this is the Ucase function.
And if someone looks at the heavy use of periods you can easily think it looks like Java. But the reason for this is not the scripting language, but the fact that macros work with so called UNO objects (if I simplify this a little bit each OpenOffice application Writer, Calc ... can be seen as UNO objects that were glewed together in a clever way) and that these UNO objects expose an Application Programming Interface (API). Because we are looking at objects a notation as oEvent.Source.Model or oTextBox.BoundField.updateString() is pretty common: Select an object as a descendant of a object hierachy and call a method of that object.

So the good news is: If you already know a programming language it is likely that you can use it for OpenOffice Macro programming: Java, C#, Javascript, Python, Basic (and even VisualBasic (Script) through something that is called COM-Automation bridge). The drawback is that the API needs to "please" all languages and this makes some parts in some of the languages more complicated as it would normally need to be. Or I can put it the other way round: It is the API, that you have to learn (70 or 80 percent) not the programming language that you use for scripting.

The Macro Forum has a sticky thread at the top of all the posts Need thorough documentation of OOo BASIC objects, which has several pointers to documentation. If it comes to macro programming in OOo Base I always recommend Roberto Benitez' page on Base Programming, particularly the last two pdf documents listed on that page.

[Villeroy]

Simply use a pattern field.

Edit mask
By specifying the character code in pattern fields, you can determine what the user can enter in the pattern field.
The length of the edit mask determines the number of the possible input positions. If the user enters characters that do not correspond to the edit mask, the input is rejected when the user leaves the field. You can enter the following characters to define the edit mask:
Character
Meaning
L
A text constant. This position cannot be edited. The character is displayed at the corresponding position of the Literal Mask.
a
The characters a-z and A-Z can be entered. Capital characters are not converted to lowercase characters.
A
The characters A-Z can be entered. If a lowercase letter is entered, it is automatically converted to a capital letter
c
The characters a-z, A-Z, and 0-9 can be entered. Capital characters are not converted to lowercase characters.
C
The characters A-Z and 0-9 can be entered. If a lowercase letter is entered, it is automatically converted to a capital letter
N
Only the characters 0-9 can be entered.
x
All printable characters can be entered.
X
All printable characters can be entered. If a lowercase letter is used, it is automatically converted to a capital letter.

For the literal mask "__.__.2000", for example, define the "NNLNNLLLLL" edit mask so that the user can only enter four digits when entering a date.

[DACM]

Simply use a pattern field.

Edit mask
A
The characters A-Z can be entered. If a lowercase letter is entered, it is automatically converted to a capital letter
C
The characters A-Z and 0-9 can be entered. If a lowercase letter is entered, it is automatically converted to a capital letter

I did not know that. Thanks Villeroy!

[Villeroy]

You're welcome