VBA Trim Left$ Right dont work in Access 2000 obj 1

[tamerlane]

Converted to Access 2000 from Access 97. VBA functions
such as Trim, Left$, Right$ ect dont work in Access but are OK in VB6. No error message given. What am I missing.

 

[gol4]

I sounds to me like you need to update your references. There are several posts in this and other access forums on how this is done as well as a FAQ. Do a keyword search.

 

[Aivars]

Hi!
You may create reference to DAO library after converting DB before running it. Place reference to DAO library into position below reference to OLE Automation (pos. 4) or into pos. 3.

Aivars

 

[Aivars]

Another little advise.

Some time when I have laziness I create new form with one textbox, write codes in the form load procedure such following:
me.textbox=trim(me.textbox)
Then I open this form and close it without saving. Now needed reference is created.

Aivars

 

[GingerR]

MS Article reference and code so it's always fixed for users

Access General Discussion FAQ
faq181-936