>is there any format available to have data entry in 'proper' case. however if they have caps on or holding Shift then it should be upper
please let me know if somebody has idea

You could use the format clauses ! and A. If the allowed length is 5 characters, then set the Format property to:

this.Format = !AAAA

The first character will be forced to uppercase; the remaining characters will be as entered. This will allow text only entry.