Re: [MS_AccessPros] Memo Field

 

So apparently you are creating value list combo boxes? I never use them since I use tables/queries as my row sources.

Again, I don't think a column value from a combo box will ever return more than 255 characters. You can use a field in a table with more than 255 characters but it has been my experience that referencing that field/column will truncate the value to 255 characters.

Duane

---

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 4:48 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Memo Field

 

I was able to copy / paste 2 pages of text from a Word document into the combo box. So it does not seem like the combo box is limited. If I try to load a Memo field from a table or query, it only loads the first 255 characters.

Sarah

---In MS_Access_Professionals@yahoogroups.com, <sarahk@...> wrote :

I am typing into an unbound combo box. There does not seem to be a character limitation.

---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

Sarah,

How are you typing directly into a combo box? 

What is the Row Source of the combo box?

Regards,

Duane Hookom

Vevey, Switzerland

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of sarahk@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, December 6, 2016 3:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Memo Field

 

Duane,

Even before I load it into the combo box, it only shows 255 characters. I am able to type more than 255 characters directly into the combo box.

Sarah

---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :

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@... [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 (11)

---

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

.

__,_._,___