Changing Text to Uppercase

[feeman]

I can change a field to upper case by using the after event function
and the following code

Me.[My Field] = UCase(Me.[My Field])

But how can you do it so that the whole form will change to Uppercase,
there are 20 fields on this form, and I would have to do the above for
all of them. There must be a faster way.

Anybody know the answer

[Bob Quintal]

"feeman" <fe*********@feehally128.karoo.co.ukwrote in
news:11**********************@h44g2000cwa.googlegr oups.com:

I can change a field to upper case by using the after event
function and the following code

Me.[My Field] = UCase(Me.[My Field])

But how can you do it so that the whole form will change to
Uppercase, there are 20 fields on this form, and I would have
to do the above for all of them. There must be a faster way.

Anybody know the answer

What excuse did you invent for having everything in uppercase?

Will you be the only user of this database?

Think about that, then if you still absolutely insist upon doing
this horrible thing, select all 20 controls, then set teh input
mask property to which will do the dirty deed.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[AP]

Here is how I would go about doing it. Put this in the forms module and
maybe on the after update of the form.

Dim ctl As Control
For Each ctl In Me.Form.Controls 'Me.Report.Controls
With ctl
If TypeOf ctl Is TextBox Then
ctl.Value = UCase(ctl.Value)
End If
End With
Next

Set ctl = Nothing

Let me know if you have any questions.
AP
www.megacrosstab.com

feeman wrote:

I can change a field to upper case by using the after event function
and the following code

Me.[My Field] = UCase(Me.[My Field])

But how can you do it so that the whole form will change to Uppercase,
there are 20 fields on this form, and I would have to do the above for
all of them. There must be a faster way.

Anybody know the answer

[Larry Linson]

"Bob Quintal" <rq******@sPAmpatico.cawrote

What excuse did you invent for
having everything in uppercase?

Maybe all the input comes from an IBM 026 keypunch?

[feeman]

Larry Linson wrote:

"Bob Quintal" <rq******@sPAmpatico.cawrote

What excuse did you invent for
having everything in uppercase?

Maybe all the input comes from an IBM 026 keypunch?

It was not an excuse it was asked by the people who use the database,
as the catolgue numbers and information are all in uppercase, so if
they forget to put the caps lock on you have some in lower and some in
upper, it is more for appearance on reports for them I think.

Not My Idea, just trying to please the people that pay the wages.

[Bob Quintal]

"feeman" <fe*********@feehally128.karoo.co.ukwrote in
news:11**********************@v61g2000cwv.googlegr oups.com:

>
Larry Linson wrote:

>"Bob Quintal" <rq******@sPAmpatico.cawrote

> What excuse did you invent for
having everything in uppercase?

Maybe all the input comes from an IBM 026 keypunch?

It was not an excuse it was asked by the people who use the
database, as the catolgue numbers and information are all in
uppercase, so if they forget to put the caps lock on you have
some in lower and some in upper, it is more for appearance on
reports for them I think.

Not My Idea, just trying to please the people that pay the
wages.

I've always loved the uppercase numbers !@#$%^&*().
Some fields should always be capitalized. Forcing other data to
uppercase just creates more problems that it's worth, and it's
ugly and hard to read, as well.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Rick Brandt]

feeman wrote:

Larry Linson wrote:

"Bob Quintal" <rq******@sPAmpatico.cawrote

What excuse did you invent for
having everything in uppercase?

Maybe all the input comes from an IBM 026 keypunch?

It was not an excuse it was asked by the people who use the database,
as the catolgue numbers and information are all in uppercase, so if
they forget to put the caps lock on you have some in lower and some in
upper, it is more for appearance on reports for them I think.

Not My Idea, just trying to please the people that pay the wages.

There are legitimate reasons to want storage in all caps. Much of the server
data that I write apps against is in an IBM AS400. Not only is much of the data
entered via terminal programs that use all upper case, but UDB400 (the database
on the AS400) is a case sensitive database.

If mixed case entry is allowed then I either have to use an inefficient query
criteria by texting against an expression that converts the fields to upper case
or I have to tell users that all text searches are case sensitive and they might
have to try various combinations of case to find their data. Neither of these
is acceptable on the larger tables so I make sure that all text is stored in
upper case.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com