Capitalize Text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I a form and table I have the format set to capitalize text to speed up the
data entry time because the people putting in the data are not speedy typers.
The problem I have is when I create a report of the data it show the text as
typed, not capitalized. Is there a way to show the text in the report
capitalized without retyping the data in the table?
 
You can do this in several ways. One is to set the format property of the
controls in the report
Format: >
 
Ron,

In addition to the other suggestions, I would generally prefer to
convert the actual data as stored to upper case, rather than just
formatting it to appear as upper case. To do this, you can put code on
the After Update event of the controls that are used for data entry on
the form, like this...
Me.NameOfField = UCase(Me.NameOfField)

This will apply to newly entered data from now on. For the records that
have already been entered into the database, you can run an Update
Query, to update each applicable field in the table to...
StrConv([NameOfField],1)
 
Back
Top