[AccessD] Rocky--re OnPaint

[Darren - Active Billing]

with regards a button's transparent property, I use it on nearly every form

Although with regards the Continuous forms I only learned it at the end of last year

With Transparent - On every form I produce I set up a button that does nothing. 

Set its visible property to true
Set its transparent property to true
Put it in the top most left corner and call it "TabBlank".
And Set it’s Tab number property to Zero
So as soon as a page opens it has the focus.
and I drop this on each form that has this "TabBlank" button

Private Sub TB()
Me.TabBlank.SetFocus
End Sub


Back in the day people would often push the space bar a few times to bring PCs out of Screen saver
(Well some regular users I had, used to do that at least :-) )
If on the odd chance a field was ’selected’ then the data would be removed accidentally. 
Often unknowingly

So that’s was the genesis of that.
But it also serves me well when the time comes to finish a procedure or a routine I set the cursor (SetFocus) often back to this hidden button by just typing "TB"
Or for a variety of reasons moving the cursor 'out of the way' or to a safe 'parking' place
I often have fields that I don’t want the focus on so for those I add "TB" to the GotFocus
other things too
Maybe a bit un-necessary…but useful (IF that’s such a thing)

And I agree - Always learning

----------------------------------------

> On 18 Jan 2024, at 1:55 am, Rocky Smolin <rockysmolin2 at gmail.com> wrote:
> 
> Well, I got a kludge that works for the client - trying to update the
> option frame when the header is true results in no change to the option
> group. To the user it appears that the group is disabled. Except not faded.
> 
> Since the header record background is already a lovely purple pastel
> there’s not reason why they should try to edit the option group on a header
> record. It would only be if they did it by error.
> 
> But thanks all for your help. After 25+ years programming Access, I learned
> a new property - transparent.
> 
> R
> 
> On Tue, Jan 16, 2024 at 9:43 PM Stuart McLachlan <stuart at lexacorp.com.pg>
> wrote:
> 
>> For other types of controls, BackStyle is as close as you will get, but
>> it's not exactly the
>> same
>> 
>> On 17 Jan 2024 at 15:34, Stuart McLachlan wrote:
>> 
>>> Yep, only buttons:
>>> 
>>> https://learn.microsoft.com/en-us/office/vba/api/access.navigationbutt
>>> on.transparent
>>> 
>>> 
>>> On 17 Jan 2024 at 15:29, Stuart McLachlan wrote:
>>> 
>>>> AFAIK, buttons are the only controls with a transparent property.
>>>> 
>>>> It is commonly used for placing the button over an image or
>>>> formatted label, effectively making the button "look good".
>>>> (Alternatively, you can think of it as making the label or image
>>>> clickable)
>>>> 
>>>> Not much use for anything else :(
>>>> 
>>>> 
>>>> On 16 Jan 2024 at 19:47, Rocky Smolin wrote:
>>>> 
>>>>> Thanks for that Jack. I did not know about the transparent
>>>>> property, even after 25 years of access programming. I am on the
>>>>> road for a few days, but when I get back I´m going to see if that
>>>>> is a little more elegant approach. I could put a text box over the
>>>>> Option frame with the back color of the text box, the same as the
>>>>> detail section. Then make it visible or not depending On the value
>>>>> of the header checkbox.
>>>>> 
>>>>> Will let you know what I find.
>>>>> 
>>>>> Best,
>>>>> 
>>>>> r
>>>>> 
>>>>> On Tue, Jan 16, 2024 at 4:14PM jack drawbridge
>>>>> <jackandpat.d at gmail.com> wrote:
>>>>> 
>>>>>> Rocky,
>>>>>> I just saw this post today and did see you had a recent post in
>>>>>> AccessD. I am sending this link in case it may be helpful in
>>>>>> resolving your recent issue.
>>>>>> 
>>>>>> https://www.access-programmers.co.uk/forums/threads/button-visib
>>>>>> le -i nvisible-in-a-continuous-form.281824/post-1682970
>>>>>> 
>>>>>> Jack
>>>>>> --
>>>>>> AccessD mailing list
>>>>>> AccessD at databaseadvisors.com
>>>>>> https://databaseadvisors.com/mailman/listinfo/accessd
>>>>>> Website: http://www.databaseadvisors.com
>>>>>> 
>>>>> --
>>>>> AccessD mailing list
>>>>> AccessD at databaseadvisors.com
>>>>> https://databaseadvisors.com/mailman/listinfo/accessd
>>>>> Website: http://www.databaseadvisors.com
>>>> 
>>>> 
>>>> --
>>>> AccessD mailing list
>>>> AccessD at databaseadvisors.com
>>>> https://databaseadvisors.com/mailman/listinfo/accessd
>>>> Website: http://www.databaseadvisors.com
>>>> 
>>> 
>>> 
>>> --
>>> AccessD mailing list
>>> AccessD at databaseadvisors.com
>>> https://databaseadvisors.com/mailman/listinfo/accessd
>>> Website: http://www.databaseadvisors.com
>>> 
>> 
>> 
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> https://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com