Search results

Me, personally, I would use basically the same code that you used there, i'd even put the code in the same spot you placed it. Try taking the values that you are checking directly from your table. If FieldName < 0 Then TextboxName.ForeColor = RGB(255,0,0) ElseIf FieldName > 0 Then...

instead of using vbBlack and vbBlue and vbRed, try using If [Current Balance] < 0 Then [Current Balance].ForeColor = RGB(255,0,0) ElseIf [Current Balance] > 0 Then [Current Balance].ForeColor = RGB(0,0,255) ElseIf [Current Balance] = 0 Then [Current Balance].ForeColor = RGB(0,0,0) End If...

What if you were to create a Macro that runs the code, then use the DoCmd.RunMacro?

How about using the RGB function? Black = RGB(0,0,0) Blue = RGB(0,0,255) Red = RGB(255,0,0) I have no idea if it will work...

Hi, I'm trying to make a database where a Date and a Service Number is entered into a form. I have 2 buttons, one to automatically enter the Current Date and the second to automatically enter the Service Number. The service number is incrimented by 1 each time and reset for every day. eg...

Hi, I'm trying to make a database where a Date and a Service Number is entered into a form. I have 2 buttons, one to automatically enter the Current Date and the second to automatically enter the Service Number. The service number is incrimented by 1 each time and reset for every day. eg...