Concatenate text and number

[eric.nguyen312]

Hi, I have a form named Invoice_frm used to create invoices. Our client
wants a duplicate form named Proforma_frm. The only difference between
the two is that the Proforma_frm adds a PF in front of the invoice
number (ex. PF8310). I've made a copy of the Invoice_frm and everything
works fine. I just dont know how to add the PF to the invoice number.
Can someone please help me?

Thanks!

 

[eric.nguyen312]

I forgot to mention that the data type for the invoice number is
numeric. Can you still add 'PF' in front of it?

Add an unbound control to the form with the control source
="PF"&[invouce Number]

Hi, I have a form named Invoice_frm used to create invoices. Our client
wants a duplicate form named Proforma_frm. The only difference between
the two is that the Proforma_frm adds a PF in front of the invoice
number (ex. PF8310). I've made a copy of the Invoice_frm and everything
works fine. I just dont know how to add the PF to the invoice number.
Can someone please help me?

Thanks!

 

[missinglinq via AccessMonster.com]

Maybe something like:

Private Sub Form_Current()
Me.InvoiceNo.Value = "PF" & Me.InvoiceNo.Value
End Sub