Can MS Access change text to all CAPS as you type it?

[NeoPa]

Dont make this so hard

me.textbox afterupdate

me.textbox = ucase(me.textbox)

For most purposes yes.

If you review post #7 though, you will see why this is not recommended in this case as the change only occurs after all characters have been entered.

[NeoPa]

Amazing how things come around. Back in the ancient of days when I was building text-based apps in IBM-BASIC, I used this method to uppercase each keystroke. Using Access, I decided it really didn't matter if each keystroke translated to uppercase and just used the input mask or

Me.txtControl.Text=UCase(Me.txtControl.Text)

.

Wow. I'm guessing that was the first basic provided by Microsoft for IBM that came built in with the IBM PC. Correct me if I'm wrong.

And yes, of course, in most cases UCase() would be fine, but the OP has specified earlier that she doesn't want the operator getting confused and/or having to worry about the CAPS LOCK key and this functionality is still available for such requirements.

[DanicaDear]

Yes, NeoPa is correct. The users of the DB aren't computer savvy and I don't want any confusion for them. If they see lower caps, they might freak out. LOL.

I do appreciate your offerings of simple solutions, topher23 and MrDeej!

[topher23]

And yes, of course, in most cases UCase() would be fine, but the OP has specified earlier that she doesn't want the operator getting confused and/or having to worry about the CAPS LOCK key and this functionality is still available for such requirements.

I caught that, I was just making an observation. I completely understand confused operators - I work in manufacturing.

Wow. I'm guessing that was the first basic provided by Microsoft for IBM that came built in with the IBM PC. Correct me if I'm wrong.

Yep, that's it. My Dad brought home a used PC-XT after I blew up my (technically his) TI-99/4A. I liked TI-BASIC/Extended BASIC a lot better than IBM-BASIC/BASICA, though.