input value based on textbox entry

[antonyx]

basically i have a textbox called

'mytext'

when my user types t1 in that textbox, and tabs to the next field, i want the value LHR - T1 to be placed inside 'mytext'

how can i do this?

 

[edtab]

In the after update of the text box:

If Me.MyText = "t1" then
Me.MyText = "LHR - T1"
End If

This will only fire if the text entered is "t1".

 

[antonyx]

thank you very much