Expression Quit working

[randifprf]

I have had this expression denoting a IDNumber
=[StudentID] & Left([FirstName],1) & Left([LastName],1) &
[InstClID]
Now It has stopped working
Get Runtime Error 2113
This is the code but I get a #Name? in the text box
containing the expression.

Private Sub InstructorPP_DblClick(Cancel As Integer)
Me.IDnumber.Value = InstIDtxt

End Sub

Taking out the FirstName and LastName makes it work but need the initials. It was working.
Any Ideas

 

[PHV]

What is the type and size of IDnumber ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[randifprf]

Text and a field size of 50