extracting partial data from one text field to another 1

[bitterman99]

I have a simple form with a field called "ORDER NUMBER" and another field called "BEX". What I'm trying to do is pull just the first 4 numbers from my ORDER NUMBER entry into my BEX field. I can get the data in a query by using the Expr: Left([ORDER NUMBER],4) expression but can't find a way to do this in my form.

Thanks!!

 

[Pampers]

Maybe this?

Dim TruncOrder as String

TruncOrder = Left(Me.[Order Number],4)

and better not use spaces in your variable/field names

Pampers
Keeping it simple can be complicated

 

[mp9]

Use the Order Number field's AfterUpdate event - in it you'd have something like:

.
.
.
If Len([Order Number])>0 then BEX=Left([ORDER NUMBER],4)
.
.
.

http://www22.brinkster.com/accessory/

 

[bitterman99]

Thanks guy's I finally got it!!