Hi Richard fantastic video this will help me the database I am working on at the moment one of the thing the customer wanted was colour checked box this is one way of getting round it there users will be able to use this way of different colours great many thanks steve.
Great video. I've been putting 'IsActive' or 'Archive' check boxes inside a Rectangle along with a couple more fields and apply this same method. My Tables include fields, (IsActiveUpdateUser, IsActiveDT, ArchiveUser, ArchiveDT) for tracking the user that changed the status and the Date/Time. On Continuous Forms I also set the Form Header BackColor to indicate the same.
I get a ton of questions every day, and I don't have time to answer them all here on UA-cam. Feel free to submit your question on my website at: 599cd.com/AskYT
Just thinking outside the box but if you can switch a checkbox by clicking on a text box and switches it’s color too, why not hide the actual checkbox and switch the green box conditional formatting to white foreground and show a check mark from a certain kind of font style? Then you literally created your own custom checkbox.
you can change the colour on a combo box with a bit a VBA: Private Sub YourComboBoxName_Change() If Me.YourComboBoxName.Value = "Condition1" Then Me.YourComboBoxName.BackColor = RGB(255, 0, 0) ' Red color ElseIf Me.YourComboBoxName.Value = "Condition2" Then Me.YourComboBoxName.BackColor = RGB(0, 255, 0) ' Green color Else Me.YourComboBoxName.BackColor = RGB(255, 255, 255) ' Default color End If End Sub
I fall for that Transparent background way too often. hehe, giggle.
Good to see it's not just me, and even the experts fall for it once in a while.
Hi Richard fantastic video this will help me the database I am working on at the moment one of the thing the customer wanted was colour checked box this is one way of getting round it there users will be able to use this way of different colours great many thanks steve.
Welcome
Great video. I've been putting 'IsActive' or 'Archive' check boxes inside a Rectangle along with a couple more fields and apply this same method. My Tables include fields, (IsActiveUpdateUser, IsActiveDT, ArchiveUser, ArchiveDT) for tracking the user that changed the status and the Date/Time. On Continuous Forms I also set the Form Header BackColor to indicate the same.
Good idea.
thanks for the video ..but i did n't know how did you to make the coloried chekbox first
Welcome
I want to learn how to do tNice tutorials but I need equipnt first any recomndations on what I should get or need
You don't need any equipment. I use a laptop, a headset, and recording software. A lot of people ask me about this. I'll be doing a video on it soon.
Awesome 👌
Thanks
How to count total data Active &inactive in form analytic?Exanple: Analytic active & analytice inactive
I get a ton of questions every day, and I don't have time to answer them all here on UA-cam. Feel free to submit your question on my website at: 599cd.com/AskYT
Just thinking outside the box but if you can switch a checkbox by clicking on a text box and switches it’s color too, why not hide the actual checkbox and switch the green box conditional formatting to white foreground and show a check mark from a certain kind of font style? Then you literally created your own custom checkbox.
Whatever works. :)
CHecK BaAxs!!!🤣
haha
you can change the colour on a combo box with a bit a VBA:
Private Sub YourComboBoxName_Change()
If Me.YourComboBoxName.Value = "Condition1" Then
Me.YourComboBoxName.BackColor = RGB(255, 0, 0) ' Red color
ElseIf Me.YourComboBoxName.Value = "Condition2" Then
Me.YourComboBoxName.BackColor = RGB(0, 255, 0) ' Green color
Else
Me.YourComboBoxName.BackColor = RGB(255, 255, 255) ' Default color
End If
End Sub