Formatting a Text Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box and in the control source I have the following:=[AFS Bank
Number] & "-" & [Customer Number]. How would I format this control source so
all numbers show up in the report (ie 03-0000555555)? It's dropping the zeros
in customer number (only printing 03-555555). Thanks in advance.
 
I have a text box and in the control source I have the following:=[AFS Bank
Number] & "-" & [Customer Number]. How would I format this control source so
all numbers show up in the report (ie 03-0000555555)? It's dropping the zeros
in customer number (only printing 03-555555). Thanks in advance.
Click to expand...

If [CustomerNumber] were a Text datatype field (which it should be)
you would not be having this difficulty. If you're not going to be
performing math calculations on the field, make it Text.

As it is a Number datatype, use:
=Format([AFS Bank Number],"00") & "-" & Format([Customer
Number],"0000000000")
 
Back
Top