>>However, the whole point of my initial enquiry was, essentially, how to bind a checkbox to a Y/N char field, without using code (I originally had an IIF() in the .value), via just the props. I've resorted to code and achieved it with far less than this. :-)
>
>Het Terry, try this.
>
>Set your TextBox.Format property to "M", and the .InputMask to "Y,N". It's not a checkbox, but it is a textbox that can only enter the values "Y" or "N" (and change via the spacebar) and no code is needed.
Thanks Fred
However, like I said to Mike:
In my opinion striking the spacebar with the thumb is a lot less hassle than finding either the Y or N key. On The Other Hand if the user uses the mouse then clicking the checkbox is, again, a lot less hassle than finding either the Y or N key.
I know you can use the spacebar via your trick but I want to keep it as a checkbox - looks a lot more up-to-date and sexy anyway. I've sorted this all with code now - not too involved
Cheers
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.