Re: [MS_AccessPros] Memo Field

 

Sarah,

This is a limitation of combo boxes. The largest text in any column of a combo box is 255 characters.

You need to grab the full value from the field in some other way.

Duane Hookom

Vevey, Switzerland

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of sarahk@schemesoftware.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, December 6, 2016 2:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

---

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

.

__,_._,___