Damm Text Boxes

[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

 

[CosmoKramer]

Chance,

Check out Tools | Options | Keyboard. Select Go to End of Field under Behavior Entering Field. The only problem is that it's a global option......