Getting part of number/ text in textbox

[caman74]

Hello everybody.

I have a form "frmForm" with two textboxes, "txtText1" and "txtText2".
In "txtText1" I insert nubers varying on lenght from 2-8 digits.
I need "txtText2" to automaticly show the first two digits from "txtText1".

How do I do this. Preferable in VBA.

Thanx.

Chris

 

[Lilliabeth]

The Control Source property of txtText2:
=Left([txtText1],2)

 

[TheAceMan1]

How are ya caman74 . . .

If [blue]txtText2[/blue] id bound, put [blue]Lilliabeth's[/blue] code above in the [blue]AfterUpdate[/blue] event of [blue]txtText1[/blue].

See Ya! . . . . . .

 

[caman74]

Thank you both!

Some things are way too easy...

 

[TheAceMan1]

Woooa . . . Scratch my previous post . . .

If [blue]txtText2[/blue] is bound, in the [blue]AfterUpdate[/blue] event of [blue]txtText1[/blue]:

[blue]   Me!txtText2 = Left(Me!txtText1,2)[/blue]

See Ya! . . . . . .

 

[caman74]

AceMan...
Thanx but I used;

Me!txtText2 = Left([txtText1,2) ,and it works perfectly.

 

[caman74]

New error follows...

Me!txtText2 = Left([txtText1],2) ,and it works perfectly.