
Signature
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000
You were right, Null is the right function. Now the second to last line is
giving me an error:
f intI > 0 Then
Me.PMemailAddress = (Me.PMemailAddress + " ") & Me.LastName & _
Mid(Me.PMemailAddress, intI)
It's telling me that .PMemailAddress is a Compile error: Method or data
member not found. What does that mean? It doesn't have a problem with it in
5 previous times it shows up, in the same code? I don't get it?
Freehal
> Right off hand, IsNothing() is not an Access function! I suspect you want
> IsNull()
missinglinq - 19 Jun 2007 18:55 GMT
The thing you have to understand is that Access frequently hilites not the
line causing the problem, but the line FOLLOWING the line causing the problem.
If you've accurately copied and pasted your code here, the problem is you
have
f intI > 0 Then
when you should have
If intI > 0 Then

Signature
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000