Capital Letters

[jk]

How do you force the text in the fields to be in a capital letter format
regardless if the user keys in small cap or large cap?The DB is already a
month old and the reports look a little off with text being large and small.

Thanks

 

[Nikos Yannacopoulos]

If you only care about how text looks (i.e. not how it is stored), then all
you need to do is go to thereport's design and set the Format property (top
on tab Format) of all the controls that display text to ">" (without the
quotes). This will force the controls to display all text in capitals.

Note: the same would work on form controls, but the text will still be
stored as entered.

Now, if you need to store only capitals, then you need to use function UCase
in an appropriate event (e.g. On Exit) to run a line of code like:

Me.FieldName = UCase(Me.FieldName)

HTH,
Nikos