Hi Richard I need the back colour of the form to change colour whilst typing details into the form , from is blue to change to green when form is completed is this possible thank you to replaying to my emails some if your lasted video have been excellent I have turned more people getting into access thank you very much live long & prosper all the best steve b
Just use code similar to my 599cd.com/ProgressBar2 video, but instead of actually setting the progress bar percentage, change the color of the form's background. Me.Section(0).BackColor
5/7/23 high Richard I really liked the progress bar solution video some of my users like that system but with some users have pore eye site I was thinking that if the form back ground colour could change say from light blue to a light green colour when the form has all fields have been completed then they know they have completed. This is because a user has very bad eye site and she is a very able person and a grate members of may staff who she gets on with everyone. Would the change of the form colour change possible, I really like the progress bar but my user would fine it easier with the colour form change. Look forward to hearing from with an idea. Live long and prosper! All the best steveb Hi Richard is it possible when editing and adding text in a form can you change the colour of the form so the user now’s that they have to enter all details of the customer is this possible in access. I look forward to hearing from you grate video by the way and interesting.
You mean change the color to something like yellow until the fields are all finished, then change it to green? Sure. That's possible. Need a little VBA, but you could definitely do it. It would be similar to this: 599cd.com/ProgressBar2 - just instead of a progress bar, change the form's background color.
Hi Richard I need the back colour of the form to change colour whilst typing details into the form , from is blue to change to green when form is completed is this possible thank you to replaying to my emails some if your lasted video have been excellent I have turned more people getting into access thank you very much live long & prosper all the best steve b
Just use code similar to my 599cd.com/ProgressBar2 video, but instead of actually setting the progress bar percentage, change the color of the form's background. Me.Section(0).BackColor
599cd.com/QQ
I think it is still possible with a vba to set the form moveable.
Yep. You can do pretty much anything in VBA.
5/7/23 high Richard I really liked the progress bar solution video some of my users like that system but with some users have pore eye site I was thinking that if the form back ground colour could change say from light blue to a light green colour when the form has all fields have been completed then they know they have completed. This is because a user has very bad eye site and she is a very able person and a grate members of may staff who she gets on with everyone. Would the change of the form colour change possible, I really like the progress bar but my user would fine it easier with the colour form change. Look forward to hearing from with an idea. Live long and prosper! All the best steveb
Hi Richard is it possible when editing and adding text in a form can you change the colour of the form so the user now’s that they have to enter all details of the customer is this possible in access. I look forward to hearing from you grate video by the way and interesting.
You mean change the color to something like yellow until the fields are all finished, then change it to green? Sure. That's possible. Need a little VBA, but you could definitely do it. It would be similar to this: 599cd.com/ProgressBar2 - just instead of a progress bar, change the form's background color.