VBA Mid Function Textbox

[gatefire08]

Hello,

Is it possible to create a text box where it allows any users to input the starting position and the length and have it update in the query?

For example, I have multiple tables, each has different starting for Last name.

I want to create a textbox where the user can change the starting position and length. Ex: LastName: Mid([Field1],textbox1,textbox2)

Thanks for your help!

 

[Cronk]

You can have a form with 4 text boxes, say
txtTableData (bound to the table field)
txtStartPosition
txtLength
txtSurname

Control source of txtSurname = mid([txtableData],[txtStartPosition],[txtSurname])