Question Colour change on forms

[bally3]

Hiya

Is it possible to change background colour of form if member has not paid fees for gym or sports etc so that staff can identify who has and has not paid and so restrict entry?

Am in middle of developing dbase for gym but client has now requested that members forms change colour when logging in via keycard or swipe card system that red if not paid and green if they have.

Anybody got any ideas - would be very grateful for any assistance as I have not come across this before at all.

Best Regards
Ian

 

[RuralGuy]

All forms have a BackColor property that can be changed at run time. Have you played with it yet?

 

[bally3]

Have only used this when changing form colour for different types of forms for id purposes etc - did not know about the run time change so will have look at this.

Many thanks
Ian

 

[bally3]

Hiya

You have read all post? I do not mean just changing colour on form etc as know how to do that but change when certain conditions alerted such as trying to gain entry to club when fees not paid etc.

So still know how, if so then please send info and I will be friend for life.

Best Regards
Ian

 

[Trevor G]

Ian try something like this.

Open the form in Design view select the properties, look for the Event On Current and then select the elipse button and select Code Builder.

Add this code, Save and change the view to look at the form, navigate a few records and it should work. By the way your thread should have gone in the forms section rather than General.

Private Sub Form_Current()
If Me.strCheck.Value = "No" Then 'Change this field name to the one you want to check for
Section(0).BackColor = vbRed
Else
Section(0).BackColor = vbGreen
End If

End Sub