Make Field Upper Case

[Nannab]

I have a field that I would like to make upper case as I type the characters in.
How do I code for that and where????

 

[boblarson]

You would need to use the text box's ON CHANGE event and you can use this code (just change the text box name to your correct name:

    With Me.YourTextBoxNameHere
        .SelStart = 0
        .SelLength = Len(Nz(Me.YourTextBoxNameHere, 1))
        .Text = UCase(.Text)
        .SelStart = Len(.Text)
    End With

 

[Nannab]

I tried the code and it is not working the way I need it to work. I think my description needs more explaining. I have a dropdown box that has values to pick from but sometimes I need to add a value. As I key the new value make each letter upper case.

If i use the current code I get an error.

 

[boblarson]

I tried the code and it is not working the way I need it to work. I think my description needs more explaining. I have a dropdown box that has values to pick from but sometimes I need to add a value. As I key the new value make each letter upper case.

If i use the current code I get an error.

I don't believe you can do this in a combo. You would need to open another form to use a text box the way I showed. See this post on how to do that:

http://www.access-programmers.co.uk/forums/showpost.php?p=819473&postcount=6