[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 555
  • Last Modified:

"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" ?
0
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
Me.txtTransN = Me.txtTempTransN & "-" & Format(Me.txtSeqN,"0000")
0
 
SteveL13Author Commented:
Perfect.  Thanks again!
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now