Question Locked

Access Memo Field to WORD Bookmark Field

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to get an Access 2003 Memo Field in a Table into a WORD 2003 Bookmark Field via VBA coding. If the memo field is 255 or less then it works fine. Anything 255 or greater then I receive an error "String Too Long" out of Access. I'm sure this is an elementary procedure I learned long ago but the recall is not there! Does anyone know what I'm missing? Thanks!

3 replies

by sgt_shultz

a memo field is constrained to 255 characters. can you change your access field type to 'text' instead? sorry if i am missing something here..

by makamkkumar

just change the default length dude o put it in asp and then search when it is in the web page ok

This discussion is closed to new replies.