Invoice Table Number!

[Bob]

I have a Invoice Table number that appears on my Report as the Invoice
Number is there anyway I can have the words (Invoice No In front of the
Number, it has a source Control "InvoiceNo"



Thanks in advance.........Bob Vance

 

[Al Camp]

Bob,
Why aren't you just placing a label next to the InvoiceNo with a caption of
"InvoiceNo:" (without the quotes)
That would be the usual way...

You could concatenate it by setting the ControlSource of your InvoiceNo to
= "Invoice No: " & [InvoiceNo]
Make sure you rename that field txtInvoiceNo, not InvoiceNo. A calculated field can not
have the same name as a legitimate field.

 

[Bob]

Thanks Al. The reason for no caption is when the numbers get longer this
will grow with it, So I would have to Guess where to put the caption for
later on...Bob

Bob,
Why aren't you just placing a label next to the InvoiceNo with a caption
of "InvoiceNo:" (without the quotes)
That would be the usual way...

You could concatenate it by setting the ControlSource of your InvoiceNo
to
= "Invoice No: " & [InvoiceNo]
Make sure you rename that field txtInvoiceNo, not InvoiceNo. A calculated
field can not have the same name as a legitimate field.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I have a Invoice Table number that appears on my Report as the Invoice
Number is there anyway I can have the words (Invoice No In front of the
Number, it has a source Control "InvoiceNo"



Thanks in advance.........Bob Vance

 

[Bob]

Al I just copied this into source Control and it worked:
= "Invoice No: " & [InvoiceNo]
Thanks...Bob

Thanks Al. The reason for no caption is when the numbers get longer this
will grow with it, So I would have to Guess where to put the caption for
later on...Bob

Bob,
Why aren't you just placing a label next to the InvoiceNo with a
caption of "InvoiceNo:" (without the quotes)
That would be the usual way...

You could concatenate it by setting the ControlSource of your InvoiceNo
to
= "Invoice No: " & [InvoiceNo]
Make sure you rename that field txtInvoiceNo, not InvoiceNo. A
calculated field can not have the same name as a legitimate field.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I have a Invoice Table number that appears on my Report as the Invoice
Number is there anyway I can have the words (Invoice No In front of
the Number, it has a source Control "InvoiceNo"



Thanks in advance.........Bob Vance