Getting part of a number

[lipin]

I have a warehouse application I have been working on. The auditors are scanning a carton barcode and this number goes into a text field on my entry form. The problem is the barcode number is00) 0 0052177740894485

the actual carton # is : 74089448

How do I get it to just enter the 7 digits actually needed when the scanner reads the whole number?

 

[wh00t]

if the carton # is of consistant length use the Mid function

e.g

barcode - (00)00052177740894485

create a new textbox and enter the below in the control source
Mid([BarCode],13,8)
will return 74089448

 

[lipin]

Since I already have the Carton Number textbox and all that linked to my table and some other forms, would it be safe to scan the original long number into an unbound textbox and have my present carton number textbox be filled with the number I need. Could I make this initial textbox invisible and still scan the barcode into it and then put the code in the afterupdate event to extract the 8 digits I need? Does invisible make it inoperable?