Saving with upper case

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi,
Howto force the saving into a table in upper case? Or how is Ucase used?
TIA
Mike
 
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.
 
You must log in or register to reply here.

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
Upper Case month 3
Force upper case in memo fields 1
make data upper case 6
Upper Case 5
Upper Case Conversion 3
CONTROL CASE - FORCE UPPER CASE 4

Back
Top