Reverse part of a string

[Guest]

[Field1] on a form holds a 9 digit number - 123456789

I need code for the AfterUpdate Event which will place the firts six digits,
in reverse order, in [FIELD2 ] on the same form - 654321
Any help, thanks.

 

[Guest]

Try

StrReverse(Left([FieldName],6)) & Mid([FieldName],7)

 

[fredg]

[Field1] on a form holds a 9 digit number - 123456789

I need code for the AfterUpdate Event which will place the firts six digits,
in reverse order, in [FIELD2 ] on the same form - 654321
Any help, thanks.

=StrReverse(Left([Field1],6))

will reverse the first 6 characters.
There is no need to store this value in [Field2].
Anytime you need to show the reversed characters, use the above
expression.

 

[Guest]

Thank you. Both work.

[Field1] on a form holds a 9 digit number - 123456789

I need code for the AfterUpdate Event which will place the firts six digits,
in reverse order, in [FIELD2 ] on the same form - 654321
Any help, thanks.

=StrReverse(Left([Field1],6))

will reverse the first 6 characters.
There is no need to store this value in [Field2].
Anytime you need to show the reversed characters, use the above
expression.