Capitalize letters in a field

[Guest]

In my confirmation number field, when letters are entered I want them all to
be capitalized. What’s the correct way of doing this? Do I set it on the
form or in the table?

Thanks
Todd

 

[SusanV]

In the form, on the textbox's After Update Event:
Me.TextboxName = UCase(Me.TextboxName)

(replacing "TextboxName" with the actual name of the textbox on your form,
of course!)

 

[Guest]

You can also easily set an Input mask in the table properties that will
capitalize that field in both the table and any resulting forms. In
properties, Input Mask line, type >CCCCC, putting as many C's as there are
required places for your confirmation field. The greater than sign forces
all caps, while the C allows any character or space, with entry optional.
For more information, See access help using keywords "Valid input mask
characters"

 

[Guest]

An even easier way to do it is to put ">" in the format field on the table
design view. This will make all chracters appear as caps.

 

[John Vinson]

An even easier way to do it is to put ">" in the format field on the table
design view. This will make all chracters appear as caps.

the key to this being the word "appear". They'll actually be STORED as
typed; in table datasheet or basic Form/Report view they'll be shown
as all caps, but that's a runtime translation.

John W. Vinson[MVP]

 

[Steve Schapel]

Agreed. This is the approach I would take.