Formatting a Text Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PJ - 08 Dec 2005 17:42 GMT

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.

Reply to this Message

fredg - 08 Dec 2005 18:05 GMT

> 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.

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")

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message