Capitals

Hudson40 · March 9th, 2005, 05:54 AM

HI all

Does anyone know a quick way of accepting text in a textbox and forcing the text to be written in capitals into a specified table?

Cheers
Tony

rjweers · March 9th, 2005, 10:05 AM

In the AfterUpdate event of the field

field = UCase(field)

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

Hudson40 · March 9th, 2005, 11:40 AM

Brilliant...cheers

Cheers
Tony

BrianWren · March 9th, 2005, 04:34 PM

Code:

    field = UCase$(field)

is better than

Code:

    field = UCase(field)

UCase$() receives a string, and returns a String. UCase() uses Variants, and is therefore just a tad slower.

rjweers · March 9th, 2005, 11:41 PM

UCase$ may be faster. However, you will need to see if the field is null before you UCase$ it. Or

field = UCase$(nz(field))

But then does the overhead of nz cancel out the benefit of UCase$?

Plus you'll store an empty string in the database. Not always the same as Null.

I figure for a data entry field UCase or UCase$... six of one, half a dozen of the other.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

BrianWren · March 10th, 2005, 01:10 PM

So if you pass a Null to UCase() it returns a Null?

That would be a significant advantage in many instances...