Concatenate text and number

  • Thread starter Thread starter eric.nguyen312
  • Start date Start date
E

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!
 
I forgot to mention that the data type for the invoice number is
numeric. Can you still add 'PF' in front of it?

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


[email protected] said:
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!
Click to expand...
Click to expand...
 
Maybe something like:

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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Back
Top