Deactivating order by on a form.

[Guest]

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

 

[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.