Strange Occurrence when Right Clicking in Form Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a form where in any date field, I have code so that right clicking in
the date field pops up a calendar where the user can select a date. I have
used this code many times before and it has always worked fine. The code is
On Mouse Down:

On Error Resume Next
If (Button = RIGHT_BUTTON) Then vdr = OpenCalendar("")

But in this particular database, when you right click in a date field the
calendar pops up, but so does a greyed out Filter option box (the same
options that you get if you go to the menu bar and select Records, except the
box also includes the options to sort and insert a hyperlink although all
options are greyed out. This box also pops up when I right click in any
other field. How can I stop this from happening?

Thanks in advance,
Janet
 
Do you have any other code on the form that might be triggering it? By
'option box' do you mean that a menu drops down, or is it kind of 'right
click context menu'?
 
Hi Rob,

I don't have any other code in the form that would be triggering it. I
don't know what to call the box other than an option box. It kind of looks
like when you to go the regular menu bar and click on "Records" what the drop
down looks like, except it's bigger and has some selections from the "Insert"
option as well. I've never seen it before. If I go to any other field than
a date field and right click, the box still appears except it's not greyed
out. I can actually select from the list.

Janet
 
Rob,

That's it! I had the Shortcut Menu Bar set to Yes. I would never have
figured that out on my own. Thank you so much!

Janet
 

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

Excel Providing user message when RED X clicked & properly closing application. 2
Pop-up Calendar on Combo box drop-down arrow Click 2
Outlook Creating an Outlook form 2
How to add a pop up calendar to date field in a subform? 3
Copy record in one form into a new pop-up form 0
Null Field to Interupt Closing 4
Calendar Control in 2007 3
Validation and Popup Calendar 5

Back
Top