Damm Text boxes 97

[Chance1234]

biggest oxymoron of all time "Microsoft Works"


Anyway, i have a textbox in a form in Access 97 and i need to protext the first 26 characters in that text box(prefix) All the usual methods such as attaching a string to the begiining of the field after update or default value in field I cant use due to the complexity of this database

Im sure there is some method under the key press event where you can return the position inside a text box

so the code would be something like

If PositionIntextbox <26 then
positionIntextbox = 27
end if

but have a feeling im thinking of a totally different language to VB

anyone got any ideas ?

Chance

 

[segmentationfault]

See if you can make this work.


Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If TextBox1.SelStart <= 26 Then TextBox1.SelStart = 27
End Sub