Converting data to appear in uppercase letters in a table

[Access Help]

I am taking a summer school class for access and one of the requirerments is
to convert data I have entered into a table to uppercase letters. I cannot
find any where how to do this. Any suggestion would be greatly appreciated.

 

[Larry Daugherty]

It may be that part of what you are expected to learn is the use of
the resources at your disposal; such as Access Help.

HTH
--
-Larry-
--

I am taking a summer school class for access and one of the requirerments is
to convert data I have entered into a table to uppercase letters. I cannot
find any where how to do this. Any suggestion would be greatly

appreciated.

 

[John W. Vinson]

On Tue, 24 Jun 2008 20:27:01 -0700, Access Help <Access

I am taking a summer school class for access and one of the requirerments is
to convert data I have entered into a table to uppercase letters. I cannot
find any where how to do this. Any suggestion would be greatly appreciated.

Open the VBA editor and search the Help for "upper case".

 

[fredg]

I am taking a summer school class for access and one of the requirerments is
to convert data I have entered into a table to uppercase letters. I cannot
find any where how to do this. Any suggestion would be greatly appreciated.

Convert existing data?
OK.
As this is a Class assignment here is how you can find the method
needed.
In Access Help, look up Query
Select
Run a query + Run an Action Query.
Click on the Update link.

In addition to the above...
Then in VBA help look up UCase.

 

[Ken Sheridan]

What's meant by 'convert'? At face value that suggests that you want to
change the data in the table permanently to upper case? Or do you merely
want to show it in upper case, while leaving the underlying values in the
original case?

For the former you'll need to run an run an 'Update' query, for the latter
you'll just need to format the columns as upper case in a query. Fred has
generously pointed you towards the UCase function for the former, and this
can also apply to the latter, though also look at how the > formatting
character is used.

You might also like to take a look at the StrConv function. One thing to
remember with this, however, is that if you use it in a query you can't use a
constant such as vbUpperCase as the conversion argument; you have to use the
actual value, in this case 1.

Ken Sheridan
Stafford, England

 

[PJHAction]

Open your form
click the field
click AfterUpdate in the properties
place this vb code

yourfield = UCase(yourfield)

 

[Wayne-I-M]

Larry, John, Fredg and Ken all gave answers that assisted the poster to gain
the knowledge required to be able to find the answer and (more importanly)
understand the process.

You gave a simple - this will do it. Your answer will work in "some"
situations but it will not allow the poster to gain any knowledge of the
underlaying Access ap-plication which I would think was what the teacher
hoped to achive by setting the question.

 

[fredg]

Larry, John, Fredg and Ken all gave answers that assisted the poster to gain
the knowledge required to be able to find the answer and (more importanly)
understand the process.

You gave a simple - this will do it. Your answer will work in "some"
situations but it will not allow the poster to gain any knowledge of the
underlaying Access ap-plication which I would think was what the teacher
hoped to achive by setting the question.

Right on the mark, Wayne!