Capitalise field value

[John]

Hi

How can I capitalise data entered into a form field during entry?

Thanks

Regards

 

[Damon Heron]

In the format property of the textbox, put a >
This only works if you don't have some other code that modifies the text
after entry.

Damon

 

[Jerry Whittle]

Put something like this in the input mask of the form or table.

CCCCCCCCCCCCCCCCCCCCC

The > converts letters to upper case.

The C's mean that any character or a space can go there. Entry is optional;
however make sure that you put in enough C's to fit the longest amount going
to be typed theere..

 

[Peter Hibbs]

In the KeyPress event enter the following code like so :-

Private Sub YourFieldName_KeyPress(KeyAscii As Integer)
KeyAscii = Asc(UCase(Chr(KeyAscii)))
End Sub

where YourFieldName is the name of your text box control.

HTH

Peter Hibbs.