Deactivating order by on a form.

P

P. Scaram

Dear Sir /Madame,

I want to deactivate the order by on form fields (when you press right click
on a field you get sort ascending , descending options) because it creates
enormous amount of locks on the sql database. There is no property
"orderbyon" on the properties screen. I also tried to set in the open form
event Me.OrderByOn = false but it did not make any difference I could still
sort ascending or descending on any field I wanted. How can I achieve that ?

Thank you in advance for your help.

P. Scaram
 
B

Brendan Reynolds

Either change the form's Shortcut Menu property to 'No' to disable shortcut
menus, or create a custom shortcut menu with only the commands you want
available, and assign the name of that shortcut menu to the 'Shortcut Menu
Bar' property. You'll find these properties on the 'Other' tab in the
Properties window in form design view.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to add sort button on form? a>z or z<a 1
Why can't I sort on the Column? 19
Sorting Find As You Type Form 1
Always Sort Date by Ascending Order? 2
How do I change the record source of a list box. 2
Subform sort order problem 2
Sort buttons on a form 8
Sorting a column based on required order 2

Top