Solved

Datasheet view form - Can't sort on a calculated field

Posted on 2014-02-08
5
787 Views
Last Modified: 2014-02-08
I have a form which opens in datasheet view mode.  There are several fields on the form that are "sortable".  But then there is one particular field that is a calculated field that I can't sort by.  Is it possible that you can't sort with a calculated field?

I have tab stop - Yes
Enabled = Yes
Locked = No

If any of that is causing this.

--Steve
0
Comment
Question by:SteveL13
  • 2
  • 2
5 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
Comment Utility
If you move the calculation to the query you use as source, it should be doable.

/gustav
0
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
You can't sort on the field because it is not part of the recordsource.  It is a property of the form.  Gustav's solution is what you need to do.
0
 

Author Comment

by:SteveL13
Comment Utility
Yes.  You are correct.  I moved the calculation to the query and removed it from the field property on the form and it works perfectly.  Thank you very much.
0
 

Author Closing Comment

by:SteveL13
Comment Utility
Excellent again.  Thank you.
0
 
LVL 49

Expert Comment

by:Gustav Brock
Comment Utility
You are welcome!

/gustav
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now