Making input data Uppercase…

Topic

New Reply

Hi everyone… Just a quick question…

I’m using Access ’97 and I have created a form that will update the underlying intermediate table… The user will navigate through records, (six fields per records) only making changes to two of the fields (where necessary)… One of the fields is supposed to be a one character text field – Upper case… I have added the > to the format criteria of the textbox (in case they make a mistake and enter lower case) but I noticed that if the user enters a lower case character…although it changes it to upper case on the form, it still updates the table with the lower case letter… I need it to change to upper case so that the data in the table is correct… as well as the report to be printed from the form…

Can anyone help me? …Any ideas would be appreciated… This is my first time creating a form for users to update data…

TIA!!

Reply | Quote

Replies

Open the corresponding table in design view and change or enter the “>” next to the FORMAT criteria below.

Hope this Helps.

Reply | Quote

Thanks Preston… I thought of that earlier… and it works… The only problem is that the underlying table is made through a Make Table query… I guess I could always just run a Delete query daily and just make an Append query so that it has up-to-date data every day… That should work right?

I’ll try it… Thanks again!
Have a great day!!

Reply | Quote

If the data is being entered through a form, add some code to the afterupdate event of the control, like this:

Private Sub TextBox1_AfterUpdate()
  [TextBox1]=UCase([TextBox1])
End Sub

That will take whatever was entered into the control and uppercase it. If the control is bound to an underlying field, the value in the field will also be uppercased, regardless of what is typed in.

Reply | Quote