Convert VALUE in Textbox to CAPS in TABLE

[taimysho0]

Hello, this is a simple question but i cant figure out how to do it. How do i get values that a user enters into a textbox to show up as all caps in the table it is linked to?


i used ">" for the format in the textbox and in the table format, but when i click in the cell of the main table, it changes it from caps to lower case (which is what the user originally entered it as). How do i make it stay as caps? thanks!

[RuralGuy]

">" is simply a display formatting option. You will need to use the UCase() function to actually change the value.

[taimysho0]

do i put that under "format" in the textbox property? sorry im not too proficient with access programming..

[RuralGuy]

Format properties are simply visual display properties. You will need code in the AfterUpdate event similar to:
Me.YourTextBoxName = UCase(Me.YourTextBoxName)
...using your real value for YourTextBoxName of course.