Fields as buttons with mouseover

[Ruegen]

Is there a way that, rather than focus, have a field change formatting when mouse over?

I don't see anything in conditional formatting that supports mouse over...



I am making fields into buttons and I would like the same affect as with a button.

[June7]

Do you mean a textbox on a form? Try the OnMouseMove event. http://www.access-programmers.co.uk/...d.php?t=112911

[Ruegen]

Do you mean a textbox on a form? Try the OnMouseMove event. http://www.access-programmers.co.uk/...d.php?t=112911

Yeah, I do apologize for my lack of proper explanation. Textbox and thanks

from what I have read from the link as I understand it you are creating coordinates within the field using VBA and changing what happens depending on whether you enter the coordinates or not?

Also is there a way of removing the selector cursor icon from appearing?

Same thing? http://www.access-programmers.co.uk/...d.php?t=122407

[Ruegen]

I've got mouse over working well - the textbox border changes colour nicely when mouse over. Returning it to it's original formatting when leaving is next bit.

[June7]

What do you mean 'coordinates within the field'? The code compares position of cursor with criteria and if true, code does something.

I did a little test with textbox. I just put Debug.Print "Move" in the procedure. Everytime the mouse passed across the textbox, "Move" was output to the VBA immediate window.

By selector cursor you mean the mouse pointer arrow? Why would you want it to go away? It can be different but don't think it can go away.

[Ruegen]

eh...

I used this and it works...

Private Sub Form_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)    
    Me.ButtonState.BorderColor = 28   'Turns border Red
    Me.ButtonState.BorderWidth = 1     'Increases border width
End Sub


Private Sub ButtonState_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Me.ButtonState.BorderColor = 255   'Turns border Red
    Me.ButtonState.BorderWidth = 1     'Increases border width
End Sub

... however, it works for all the fields on a continuous form rather than the particular one I am hovering over...

[Ruegen]

What do you mean 'coordinates within the field'? The code compares position of cursor with criteria and if true, code does something.

Nevermind

By selector cursor you mean the mouse pointer arrow? Why would you want it to go away? It can be different but don't think it can go away.

Yup. Mouse pointer arrow insert thing.

I want the formatting to go back to it's original state once the mouse moves away from the text box, which it now does - however, I want one record only - not all on a continuous form.

This is how I would like it to turn out.

All it does at the moment is change the formatting for all rather than just one record.

[June7]

That's probably because there really is only one control. It's the same when trying to change a property of a control on continuous form, the change is in effect for all instances of the control. In the same vein, the same procedure is executed for all instances of the control when cursor passes over. Don't think you can get what you want.

[Ruegen]

That's probably because there really is only one control. It's the same when trying to change a property of a control on continuous form, the change is in effect for all instances of the control. In the same vein, the same procedure is executed for all instances of the control when cursor passes over. Don't think you can get what you want.

Yeah I guess so, I went with buttons in the end and it's working fine (and frankly it's easier to code in).