Changing text on an Inputbox within a form

[shaz123]

I have an input box which appears once a command button is clicked on, Once the inputbox appears a message the message displayed is "Do you wish to fill a cylinder for works order number:-0003102647000001

What i need to do is split the two numbers 003102647 and 000001. It should say "Do you wish to fill a cylinder for Works Order Number 003102647 and For Line Number 000001". How would i amend the following code to do just that, the coding i am using is

My Code:

InputBox("Do You Wish To Fill A Cylinder For Works Order Number:-" & [Works Order Number] & [Line Number], "Please Enter/Scan Cylinder Serial Number")

Any Ideas how to change my code to do this, i have tried but keep getting errors.

 

[Crowley16]

add another section of text between the 2 numbers...

"blah:-" & [fldNme] & " something " & [fldNme] & "..."



--------------------
Procrastinate Now!

 

[shaz123]

Thankyouuuuuu So much that worked

 

[TheAceMan1]

How are ya shaz123 . . .

Just my 2 cents. If the character count remains the same try this:

[blue]   Dim Prompt As String, NL As String, DL As String, rtn
   
   NL = vbNewLine
   DL = NL & NL
   Prompt = "Do you wish to Fill a Cylinder for:" & DL & _
            "Work Order Number " & Left(Me![Works Order Number], 9) & NL & _
            "           Line Number " & Right(Me![Works Order Number], 6) & DL & _
            "Please Enter/Scan Cylinder Serial Number"
   rtn = InputBox(Prompt, "Works Order Number Data Entry! . . .")[/blue]

See Ya! . . . . . .

 

[shaz123]

thankyou for ur reposnses