"How format 4 digit number in a combined text field?"

I have this code which isn't working quite right.

    Me.txtTempTransN = Me.cboTransferral
    Me.txtTransN = Me.txtTempTransN & "-" & Me.txtSeqN

What is happening is the 2nd line of code is working ok except for the last part of it.

Me.TempTransN is formatted so a number like 0001 is actually showing up as "0001" because someone helped me format the field in the table as 0000.

But now the combined field (Me.txtTransN) is showing the last part as just a "1" instead of "0001" (after the "-")

How can I make it "0001" ?
SteveL13Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
Me.txtTransN = Me.txtTempTransN & "-" & Format(Me.txtSeqN,"0000")
0
 
SteveL13Author Commented:
Perfect.  Thanks again!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.