Question Database Coordinator/IT Analysis

[Mrkeith]

Gina, after changing to design view in the Properties window under the format tab. You only have Autoresize not Autosize. I've changed that to no, but nothing happen. I'm I doing this right?

 

[GinaWhipp]

Oops yep it is called AutoResize... But you also have to size the form to the size you want by dragging the outer edges.

 

[GinaWhipp]

Stepping away from machine for a little bit so don't panic if I don't answer right away. If someone does not come along to help I will be back.

 

[Mrkeith]

Yes, I have it. Thank you so much. Hey what about the cursor hover over the check box and it shows the information in the comments box. You have any thoughts?

 

[GinaWhipp]

Are you saying you want to display the contents of the comments box in a Control Tip when you hover over the Checkbox?

 

[Mrkeith]

Yes, but will the information be updated once the user adds information to the comments box?

 

[GinaWhipp]

Let's try something like...

Me.Check110.ControlTipText = Me.TheNameOfYourNotesField.Text

 

[Mrkeith]

Gina, can i just copy/paste this into the visual basic program in between the script. Also what if i send you a sample of what i'm working on?

 

[GinaWhipp]

You can't copy paste the above because I don't know the name of the Text Notes field. You can send the sample but as I am now on my way out the door I will not get to it until later tonight OR tomorrow.

 

[Mrkeith]

ok, thanks Gina. Talk to you tomorrow.

 

[GinaWhipp]

Did the line of code I gave you work?

 

[Mrkeith]

The form script work. Thanks, but the mouse over or hover over the check box did not work. Any ideas?

 

[GinaWhipp]

Did you get any message at all? And what event did you put it on?

 

[Mrkeith]

I put the script in the After Update event and I even tried On mouse down event as well.

 

[GinaWhipp]

You need to place in the On_Current event of the form AND in the After_Update event of the checkbox. Note, I never asked if this was a continuous form because this will not work if it is one.

 

[Mrkeith]

I received an error message (Compile Error: Method or data member not found)

 

[GinaWhipp]

Please copy paste what you have here...

 

[Mrkeith]

There is nothing there.

 

[vbaInet]

Gina,

I wonder if the Zoombox would be useful in this case?

 

[Mrkeith]

Maybe. That might work. But where is it located. I don't see it.