I'm going to assume that you want this for display purposes only. If this is indeed the case then the return sample attachement will do the task.
Here is how it was accomplished – first put your Form into Design View:
1) Rename the Product TextBox to ViewProduct. 2) Make sure this new ViewProduct TextBox contains nothing in the ControlSource property (make it unbound). 3) Create another new TextBox near the bottom of the form (where the other non-visible controls are) and name it Product. 4) Set the Visible property for this new Product TextBox to False (so it can’t be seen). 5) Set (bind) this new Product TextBox ControlSource property to Product. 6) Open the VB code editor and locate the Function named ‘ChangeView’. Change the line that states Me.Product.Visible = I to Me.ViewProduct.Visible = i 7) Get out of the VBE and back to Form. Enter this code into the Forms’ OnCurrent event so that it looks something like this:
Private Sub Form_Current() If IsNull(Me.ProductCode) Then MsgBox "There appears to be no Product Code for this item." & vbNewLine & _ "A Product Code should be supplied.", vbExclamation, "No Product Code" End If Me.ViewProduct = Me.ProductCode & " - " & Me.ProductEnd Sub