Capitalization on forms

[jimleon]

Hello gurus

I have a text box on a form that is used to enter data in the format a99v which is bound to a table. How do I auto capitalize the form field and the entry in the table. Thought it was easier than its proving to be!

Many thanks in advance

[Rabbit]

Never heard of that format. Are you talking about an input mask? Put > in front and it'll convert everything to capital letters.

[jimleon]

putting the > in the format box will indeed capitalize the contents of the form field but the contents of the table it is bound to stays at its original lowercase format.

Never heard of that format. Are you talking about an input mask? Put > in front and it'll convert everything to capital letters.

[Rabbit]

putting the > in the format box will indeed capitalize the contents of the form field but the contents of the table it is bound to stays at its original lowercase format.

That's because you have to tell the input mask to store with the input mask in the table. To do that you have to attach ;0 at the end of the input mask.

[rockdc1981]

create this module

Option Compare Database
Option Explicit

Public Function UpperCase()
'Test if control contains text
    If IsNull(Screen.ActiveControl) = False Then
'convert text to Proper Case
        Screen.ActiveControl = StrConv(Screen.ActiveControl, vbUpperCase)
    End If
End Function
Public Function LowerCase()
'Test if control contains text
    If IsNull(Screen.ActiveControl) = False Then
'convert text to Proper Case
        Screen.ActiveControl = StrConv(Screen.ActiveControl, vbLowerCase)
    End If
End Function
Public Function ProperCase()
'Test if control contains text
    If IsNull(Screen.ActiveControl) = False Then
'convert text to Proper Case
        Screen.ActiveControl = StrConv(Screen.ActiveControl, vbProperCase)
    End If
End Function

then call any of the function u want on the after update of any field

after update=UpperCase()

this will turn ur data into upper caseor any way u want to...good luck

[NeoPa]

That's because you have to tell the input mask to store with the input mask in the table. To do that you have to attach ;0 at the end of the input mask.

This is the answer you need.
This needs to happen automatically so a function, though a good idea for some cases, is probably not appropriate in this case. Good idea though Rock