Saving with upper case

  • Thread starter Thread starter Mike
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Force Upper/Lower case on Month 2
Upper Case 3
Force upper case in memo fields 1
Upper Case month 3
make data upper case 6
Upper Case 5
Upper Case Conversion 3
CONTROL CASE - FORCE UPPER CASE 4

Back
Top