Need additional Event Solution

[Adrianna]

Okay....I'm trying to provide refferencial data for my clients that will provide a description of the fields that they are filling in.

The ControlTip provides them with a brief description of what they need to fill in the field (I'm put into place input masks, formatting, and validation where possible).

Now I want to add additional referencial information.

My idea was to use the Mouse Right-click or DblClick() to deplay a message box with the formal definitions and requirements for the information that the clients will be reporting. Works great on textfields, but on Yes/No check boxes...the DblClick() changes the value of the field and then displays the message.

So....I need to either provide another option, like pulling a "?" icon to the field that they want defined......

Or

I can test for the status of the field....display the message and return the field back to it's original state! This does work...I've tried it, but I was hoping that I could do something else.

 

[charityg]

Just an untested idea that I'm throwing out there for you. Have a ? command button on the form or a toolbar. When the button is clicked, set a public flgCancel variable to true and change the cursor icon to a ?. When a field is clicked, set cancel=flgCancel in the BeforeUpdate event of the control and in the click event, if flgCancel=true, display your MsgBox. I guess the ?Commandbutton would have to toggle, or you would reset the flgCancel to false after a Msgbox appeared. This would probably depend on how you see the user utilizing the feature. Would you want them to click the ?Command once to turn it on, and view the feature messageboxes, or would they click the ?command view one feature messagebox and continue until they needed it again. Anyway, just an idea.

 

[Adrianna]

Wow...a little confusing, but I will give it a try later today or tomorrow after my VTC.

If I have any questions or actually get it to work....I'll post back!