String Functions report #Error ??? 1

[balin]

I use these functions all the time Excel, Access etc.
Left, Right, Mid, Len etc.

I was trying to extract from a Text field and all of a sudden useing Mid([text],3,4) gives #Error. I'm inserting this in a query and addressing a known text field in a linked table. Basic stuff but ??

I have this type of function working on fields in other access databases (mdb) No probs. I even tested an older version of the one I'm currently working on - no problems.

Is there some kind of corruption??

JON

 

[balin]

Forgot to say environment is, Access97 ,Win2000
JON

 

[jsteph]

Are you using Mid$() or Mid()?

Mid$ will return error if you reference a NULL field, Mid() will not.
--Jim

 

[MajP]

It has to do with your VB references. I wanted to see if I had the same problem and I could not figure out what was going on. I ran the mid function and got a reference not found error. I set the rerence to Visual Basic For Applications and it works. If it is already checked uncheck it and recheck it with the most current version.

 

[dhookom]

This sounds very much like a references issue. Check this link

http://allenbrowne.com/ser-38.html.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[balin]

Yes guys that was a references issue. I unchecked the reference to the MS DAO library which removed the #Error then rechecked the latest version present on the machine. DAO 3.6.

All is well. Much apreciated. I'm not real good with Code. Most of my work is done with Macros so thanks.

JON