M
Mike
Hi,
Howto force the saving into a table in upper case? Or how is Ucase used?
TIA
Mike
Howto force the saving into a table in upper case? Or how is Ucase used?
TIA
Mike
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve Schapel
Mike,
In the AfterUpdate event of the textbox on your form, put code like
this...
Me.YourField = UCase(Me.YourField)
- Steve Schapel, Microsoft Access MVP
In the AfterUpdate event of the textbox on your form, put code like
this...
Me.YourField = UCase(Me.YourField)
- Steve Schapel, Microsoft Access MVP
K
Ken Snell
Assuming that you're using a form to enter the values and then save them to
the table, you can use the form's BeforeUpdate event to convert a control's
values to uppercase before saving the data to the table.
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.ControlName.Value = UCase(Me.ControlName.Value)
End Sub
If you have multiple controls that need to have this done, you can add more
code steps using their names.
the table, you can use the form's BeforeUpdate event to convert a control's
values to uppercase before saving the data to the table.
Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.ControlName.Value = UCase(Me.ControlName.Value)
End Sub
If you have multiple controls that need to have this done, you can add more
code steps using their names.