how do i change the text case in access?

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

Guest

i am setting up a form in access 2003 which contains contact information
(names and addresses). at present, most of the text is either in all
upper-case or all lower case. how can i quickly convert the text to all
upper-case?
 
alex said:
i am setting up a form in access 2003 which contains
contact
information (names and addresses). at present, most of the
text is
either in all upper-case or all lower case. how can i
quickly convert
the text to all upper-case?
Click to expand...

Create an update query that uses the function UCase() to
convert the case. It won't affect fields that are already
upper case.

Look up the Access Help for UCase() and for Action Query -
Update.

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----
 
In your form, go to design view, and display the
properties for the control that you want to display in all
uppercase and under the Format property, type the ">"
character (without quotes) to display in uppercase. This
will not actually change your data in the table, but will
display it as you want.
You can also do this in design view of table, in the
format property of a field. Conversely, the "<" character
will display all lowercase.
 
Back
Top