Changing Text to All Uppercase 1

[labprof]

How would I change the text so that when the user enters information into a form field is always changes the text to all upper case.

I know that I need to use the after update command....

I have a field on my form called Customer.

I always want the customer name to appear as CAPITALIZED.

Any help would be appreciated.

Labprof

 

[straybullet]

In the format for the Customer name control, put a >.

This will display the text as uppercase in the form, but will not affect how it is stored in the table.

Let them hate - so long as they fear... Lucius Accius

 

[labprof]

Thanks Straybullet....

But what if I want it to save in the table as CAPITALIZED?

I will be using the data enter into this field on a report and I want the Customer Name always to show up capitalized on the report.

Any ideas?

Labprof

 

[straybullet]

Using the > on the form (or report) will display the text as uppercase, to save it as uppercase in the table, use the > in the field properties

Let them hate - so long as they fear... Lucius Accius

 

[labprof]

Thanks Straybullet!

That worked GREAT.

Labprof

 

[TheAceMan1]

How are ya labprof . . .

In the controls [blue]On Key Press[/blue] event copy/paste the following:

[blue]   If KeyAscii > 96 And KeyAscii < 123 Then
      KeyAscii = (KeyAscii And 223)
   End If[/blue]

See Ya! . . . . . .