Solved

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

Posted on 2013-05-31
2
545 Views
Last Modified: 2013-05-31
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
Comment
Question by:SteveL13
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39211628
Me.txtTransN = Me.txtTempTransN & "-" & Format(Me.txtSeqN,"0000")
0
 

Author Comment

by:SteveL13
ID: 39211635
Perfect.  Thanks again!
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question