Is there anyway to sort fields which data type is memo, because unlike other data type can sort. Any suggestions are highly appreciated.
Hi eneyardi
I managed to find a ac2007 to test on. You are correct that in table, query and form view, the built in accesss sort button gets disabled when switching to a memo type field. Why MS choose to do so I really don't know.
That said you can still specify that you want to sort by that field in query design view, or even specify it at runtime in a form, by for example clicking on a label with appropriate code attached: - Me.OrderBy="[MyMemoField]"
-
Me.OrderByOn=True
You are correct that any sorting performed on a memo field will only base its sorting on the first 255 charecters.
For clarification, the reason I asked about whether your tables were linked or not, waas that I was curious that your issue might be related to your database being linked to for instance an SQL server as opposed to internal access database. I didn't think that access would intentionallly disable the sort for memo fields.
7 6353
As far as I know your perfectly able to sort on memo fields. The main thing to be aware of is that Access will only base its sorting on the first 255 charecters of that memo field.
In my table name tblARE, i have a field name Item, Description and Remarks. Both Item and Remarks data type is text are able to sort, but the description field set to memo cannot be sort. i don't know why it can't be sort.
When i selectall the Description field, the sort button becomes disable, but when selectall the other fields that data type is text, the sort button is enable so that the sorting works. i don't know why is not working on memo field..
All I can tell you is that in Ac2003 working on a database in Ac2000 format, I can sort on my memo fields. What version of access are you using, and are your tables local, or linked, and if linked, what are they linked to?
My table are link to many form as queries. Only the field Description w/c data tape is memo is the only field that i can't sort, according to what i have researched before (sorting fields), is that the sorting process has a limited number of characters to be sorted. maybe that's why in memo field it cannot. Correct me TheSmileyCoder if I'm wrong..
Hi eneyardi
I managed to find a ac2007 to test on. You are correct that in table, query and form view, the built in accesss sort button gets disabled when switching to a memo type field. Why MS choose to do so I really don't know.
That said you can still specify that you want to sort by that field in query design view, or even specify it at runtime in a form, by for example clicking on a label with appropriate code attached: - Me.OrderBy="[MyMemoField]"
-
Me.OrderByOn=True
You are correct that any sorting performed on a memo field will only base its sorting on the first 255 charecters.
For clarification, the reason I asked about whether your tables were linked or not, waas that I was curious that your issue might be related to your database being linked to for instance an SQL server as opposed to internal access database. I didn't think that access would intentionallly disable the sort for memo fields.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Jacky11 |
last post by:
When combining in a query a field with MEMO Data type and a field with
TEXT Data type like this
Caption: ! & !
The query will not Display/Export more than 256 characters.
The field is a Memo...
|
by: mbev |
last post by:
Is it possible to add more than 65,000 characters in a field in Microsoft
Access 2003? With the data type "MEMO" only let me add 65,000 characters.
Thanks in advance.
|
by: Martin Lacoste |
last post by:
Is there some issue with using too many left/right/mid/len functions
in queries? Depending on the usage, they work fine, but... then
there's here:
SELECT Master_CAO.Incipit,...
|
by: Brian Henry |
last post by:
is there info about data type conversions between access to ado.net? I have
tried a lot of the ones that say oledb data types should work for and get a
lot of "data type mismatch" errors using...
|
by: mesut demir |
last post by:
Hi All,
When I create fields (in files) I need assign a data type like char,
varchar, money etc.
I have some questions about the data types when you create fields in a
file.
What is the...
|
by: Mejmeyster |
last post by:
Hi Everyone,
I have a table in which one of the text fields has become too small (since it only holds 255 characters). To remedy that, I'm trying to change the data type of that field to "memo"...
|
by: RMC |
last post by:
Hello,
I'm looking for a way to parse/format a memo field within a report.
The Access 2000 database (application) has an equipment table that
holds a memo field. Within the report, the memo...
|
by: Dilruba |
last post by:
I want retrieve data from Ms Access 2000 database by using ASP and data type memo and after that i want e-mail that data automatically
|
by: Dilruba |
last post by:
I have tried to take Memo (Access 2000) data type in a Dim variable.
After that i have send it via e-mail text. But it is not sending the vaule.
Here is the code that i have used:
<% Dim msgDb...
|
by: ritu raj shriwastaw |
last post by:
I am using window xp and php trait(php3.1,mysql4.2).i have one field is of memo data type and I am unable to retrieve data from that memo data type field.
what query I should write?
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |