Select the first 6 charaters from a text box 2

[Moss100]

I would like to select the first 6 characters from a text box and use something like a 'setvalue' command to transfer this into another text box. Any ideas how I get access to just select the first six characters?

Many thanks

Mark

 

[HarleyQuinn]

I would look into using the Left() function.

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[Remou]

You can use Left:

[tt]txtOtherTextBox=Left(txtTextBox,6)[/tt]

 

[Moss100]

If i create a new taxt box called say text200 and i want to display the first 6 characters of a textbox, text188, what would i write in the control source of text200??

i.e to display the full contents of text188, I would write in the control source of text200 "=[text188]"

Sorry for being so dumb!

Thanks

 

[Moss100]

All done, thanks guys