On Mouse Move in a continuous form

[mrtn]

Hi

As mentioned above I've got a continuous form with a bunch of textboxes.

What I am trying to achieve is to underline a value of a specific textbox with an on mouse move event.

From what I can see the default is that all values of a specific fields are underlined if the mouse pointer hovers over any of the field values - textboxes on the form. Is it possible to underline just the one - kind of a highlight style?

 

[gemma-the-husky]

with a continuous form, you will possibly have to use conditional formatting to give cells a unique treatment. You might be able to get the mouse to set a control flag of some sort, and then you should be able to get the formatting to change, depending on the control flag.

The trouble is there is only a single detail row specified, so formatting gets applied to all rows. In point of fact, a "single" form will probably be the same, but you don't notice it, because you only see one row at a time, in effect.

ie What happens with your underline setting in a normal form, if you move to a new record?

Another way you might be able to do it, is by using rich text fields, rather than normal text. This is new to me, as I tend to use A2003, which doesn't have rich text fields.

Any other ideas around?

 

[mrtn]

OK thanks for this.

Basically I've switched from a datasheet view into a continuous form because it gives me a bit more flexibility. Can't really use a single form as I need a number of records to be displayed at the same time.

THe underline setting seems to work fine but not how I'd like it to. I've set it to underline if mouse pointer hovers over a textbox and then remove underline if no longer hovers that field. It underlines a textbox in multiple rows at the same time.

I am intrigued by your first suggestion of setting a flag - I'll try and give it a go. Thanks

 

[theDBguy]

Hi. As was already mentioned, there's really only one control but displayed multiple times. So, anything you do, via code to one of them, will be reflected on all of them. The only true way to format them differently is through Conditional Formatting. So if you could somehow figure out a way to use Conditional Formatting with the OnMouseMove event, then it's probably the only way you can get what you want. Good luck.

 

[Deleted member 147267]

Can't really use a single form as I need a number of records to be displayed at the same time.

Maybe a split form would help, although I confess to not being a fan of them. I can think of no way to set a flag that will relate to the current record because a mouseover event won't pick up what record you're over. Maybe you could count records based on cursor position relative to form border by factoring in the row height. IIRC, most who attempt interacting with a datasheet/continuous form and mouseover give up because simply clicking on a record solves everything.

 

[gemma-the-husky]

The idea of setting the flag was to use that in conduction with the conditional formatting - you need a way to distinguish rows at table level.

sort of underline where (flag = true)

Is the idea of rich text any good - that's a similar thing really, but wouldn't need conditional formatting, which would make it more responsive.

you would have to edit the text to add the formatting codes as you hovered over. Then the data would carry it's own formatting, so there would be no issue with it being a continuous form. The codes in rich text fields are just html tags as far as I can see

controlname = openunderlinetag & [controlname] & closeunderlinetag, for the entire field
similar to remove the tags.


If @micron is right about mouseover not picking a single row, then it still won't work.

 

[missinglinq]

Also understand that if you get this to work...it's going to do the Conditional Formatting based on the Record that currently has Focus!

In other words...if the first Record has Focus...and you hover over your Control on the 5th Record, without first moving to the 5th Record and giving it Focus (making it the Current Record) the Formatting will be based on the Value of that Control in the 1st Record...not the Value of that Control in the 5th Record.

Linq ;0)>

 

[Deleted member 147267]

..if the first Record has Focus...and you hover over your Control on the 5th Record, without first moving to the 5th Record and giving it Focus (making it the Current Record) the Formatting will be based on the Value of that Control in the 1st Record...not the Value of that Control in the 5th Record.
Linq ;0)>

thank you for seconding the notion (or is it motion?)!

I can think of no way to set a flag that will relate to the current record because a mouseover event won't pick up what record you're over.

 

[missinglinq]

Sorry, Micron...missed that in reading your post!

Linq ;0)>

 

[gemma-the-husky]

I thought I would have a look around, and found quite a few examples, of similar requests. The last one might help mot - you may need to subscribe to see the thread.

https://www.experts-exchange.com/articles/3506/How-to-code-Mouse-Over-effects-for-MS-Access.html

this old post, that linq contributed to!
https://bytes.com/topic/access/answers/677433-continuous-forms-mousemove-give-popup-modal-form

this might help
https://www.experts-exchange.com/qu...rrent-on-MouseMove-in-continuous-subform.html