Getting Number

[Daniel]

Hello all,

I have a two text boxes, first in txtFieldNumber and the second is txtGrid.
Users type in the field number ex. 342374587. The grid is ALWAYS the 4th
and 5th position in that field so in this case it is 37. I need help on how
to automatically fill the txtGrid with this value.

Thanks,

Daniel

 

[Rick B]

= mid([txtFieldNumber],4,2)

 

[Rick B]

One more point. This would not need to be a field in the table. That would
be redundant. When you need this value, just pull it out as I demonstrated.

Rick B

 

[Daniel]

Rick,

Thanks for the quick reply. I knew it had to be simple.

Daniel

 

[PC Datasheet]

Keep in mind the two digits will be a string and not a number!