Forcing Upper Case

[ViRi]

Hi

I have a simple database where I wish to force only Upper Case text even if user inputs Lower Case text, how can I do this?

ViRi

 

[RuralGuy]

Put Me.txtBox = UCase(Me.txtBox) in the BeforeUpdate event of the textbox. Using *your* txtBox name of course. There are 2 or 3 other methods to do the same thing.

 

[ViRi]

Hi RuralGuy

Thanks for your help I tried your method and I got a runtime error like this
Function set to the BeforeUpdate is preventing the data from being saved in the field.

ViRi

 

[RuralGuy]

Use the AfterUpdate event then. Sorry.

 

[ViRi]

It works fine now thanks

 

[RuralGuy]

You're welcome. Glad I could help.