How to change backcolor (but not when first opening the Form)

[sjr1917]

By my "just add this" in the previous comment... I meant "just add this to the test code I already provided in the sample db."

 

[reddevil1]

Hopefully I have converted correctly to 2003 version....

Unfortunately, i couldnt work out how to convert 2010 to 2003? i did "Save Database As" but th eonly option was to 'Save As Type' Microsoft Access Database, but no option for2003 or 2007 version?

Does anyone know how to save to an earlier version?

 

[reddevil1]

sjr1917

Private Sub ContractID_Change()
ContractDetails.BackColor = 9170175 ' Yellow focused color
End Sub

That's really great help sjr. Now it works like a treat - thanks for all your patient guidance.

I guess i was hopefult that code in the OnFocus and Lost Focus would be sufficient, but extra code needs to also go in OnChange (or OnClick) to cover every possibility.

Just hope I remember to change all the Event coding if i ever decide to change to a different colour scheme