Page 1 of 1
How do I make entry all caps
Posted: Thu Feb 23, 2012 3:48 am
by mktork
Is it possible to make the data entered into my forms be all capital?
Re: How do I make entry all caps
Posted: Thu Feb 23, 2012 9:24 am
by DACM
mktork wrote:Is it possible to make the data entered into my forms be all capital?
Edit: See Villeroy's post below... Villeroy wrote: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
Re: How do I make entry all caps
Posted: Tue Feb 28, 2012 11:58 pm
by 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
Re: How do I make entry all caps
Posted: Wed Feb 29, 2012 12:39 am
by 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.
Re: How do I make entry all caps
Posted: Wed Feb 29, 2012 9:43 am
by Villeroy
Simply use a pattern field.
F1 Help wrote: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.
Re: How do I make entry all caps
Posted: Wed Feb 29, 2012 6:36 pm
by DACM
Villeroy wrote:Simply use a pattern field.
F1 Help wrote: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!
Re: How do I make entry all caps
Posted: Wed Feb 29, 2012 6:44 pm
by Villeroy
You're welcome
