I thought of 2 images but felt it would look clunky
Or a 2 value slider .. also clunky
I thought it would be a neater way of setting program settings than a Yes/No or On/Off combo
However, unless there's a ready made control, it isn't really worth the effort
I was thinking of 2 images also. And thinking setting a default, then on click revert to other image, but it seems clunky (if doable, at best). Saw this from Gina, but no already built control.
you can use a button - use format to select a quick style but you would need code to set border, back and fore colors - plus code to change the alignment. Use Windings font (lowercase L) or webdings (lowercase N)
the code would be something like
Function formatButton(isOn as Boolean, ctrl As Control)
If isOn Then
ctrl.BorderColor = vbBlue
ctrl.BackColor = vbBlue
ctrl.ForeColor = vbWhite
ctrl.Alignment = 3
Else
ctrl.BorderColor = vbBlack
ctrl.BackColor = vbWhite
ctrl.ForeColor = vbBlack
ctrl.Alignment = 0
End If
It never occurred to me to use Quick Styles - in fact I tend to forget they exist!
2 minutes work & I have exactly what I wanted!
The hover colour bit was also easy
Definitely worth giving you more RPs but the forum rules won't let me do so again
So all I can do is to say a very merry Xmas to you as well Chris
EDIT: Now if you can also help me retrieve my own code from an accde file where I've deleted the original accdb, I'll know for sure Santa Claus exists ...
Thanks Jack.
That's good to have in reserve for future reference
However Santa really has arrived as I found the old accdb file
And much more importantly I've just become a proud grandparent in the last half hour. Baby boy born just after 1am on Xmas day
This article is the first in an occasional series of additional controls that can be added to Access without requiring ActiveX functionality. It shows how to create a simple on/off toggle slider control
www.isladogs.co.uk
The article was noticed by Mike Wolfe who has taken the idea further in a series of three articles starting with: