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

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
SteveL13Asked:
Who is Participating?
 
Gustav BrockCIOCommented:
If you move the calculation to the query you use as source, it should be doable.

/gustav
0
 
PatHartmanCommented:
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
 
SteveL13Author Commented:
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
 
SteveL13Author Commented:
Excellent again.  Thank you.
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.