SQL:
The link you provided: http://allenbrowne.com/ser-63.htm states very clearly:A Memo field in the Row Source of a combo box or list box will truncate.
Read this from Allen Browne: http://allenbrowne.com/ser-63.html
Darrell
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, December 08, 2016 1:53 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Memo Field
What is the query that is the row source property for the combobox? Please post the SQL.
Darrell
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, December 08, 2016 1:50 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Memo Field
Let me explain better:
My combo box has a query as its row source, but is not limited to list.
In order to test if the combo box box is limited to 255 characters , I pasted 2 pages of text from a Word document to the combo Box and I am able to see that the Combo Box is not limited to 255 characters.
When I use the query to populate the combo box, it is limited to 255 characters, When I use . Dlookup in VBA to populate the combo box it can go beyond 255 characters.
Sarah
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
Hi Sarah,
I guess I'm confused. Does your combo box have a query or table as its Row Source? What is the Row Source?
What do you mean by "copy / paste 2 pages of text from a Word document into the combo box"?
Regards,
Duane Hookom
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of sarahk@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Wednesday, December 7, 2016 4:52 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Memo Field
When I use Dlookup, I am able to load more than 255 characters in the combobox.
Dont understand why Dlookup works, but not query.
Sarah
---In MS_Access_Professionals@yahoogroups.com, <duanehookom@...> wrote :
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@... [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
The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.
Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.
The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.
Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.
Posted by: sarahk@schemesoftware.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (18) |
Tidak ada komentar:
Posting Komentar