Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    May 2002
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Making input data Uppercase...

    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!!

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    La Verne, California, USA
    Posts
    313
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making input data Uppercase...

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

    Hope this Helps.

  3. #3
    Lounger
    Join Date
    May 2002
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making input data Uppercase...

    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? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    I'll try it... Thanks again!
    Have a great day!!

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Making input data Uppercase...

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

    <pre>Private Sub TextBox1_AfterUpdate()
    [TextBox1]=UCase([TextBox1])
    End Sub</pre>


    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.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •