[MS_AccessPros] Memo Field

 

I have a table that has a Memo field defined. 

I use a query to select the fields and load the Memo field into an unbound combo box on a form.

 The problem is that only the first 255 characters of the memo field are loaded in the combo box.

I checked the query and it shows the full length of the memo.

My vba:

Me.PROBLEMCOMBO = Me.selcp.Column(1)

VBA does not 'see'  Me.selcp.Column(1) as a Memo field. I deubg.print Me.selcp.Column(1 and it shows only the first 255 characters.

How do I define a Memo in VBA?

I am using MS Access 2003

Thanks for your help

Sarah

__._,_.___

---

Posted by: sarahk@schemesoftware.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___