var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Date Expression Problem
Another problem came up with my form.
In my form I have a field called Loan Date and Expected Return Date.
I would like to check whether todays date is bigger than the Expected Return Date and if so color the Expected Return Date Label.
I tried adding this code
If txtExpectedReturnDate >= Date Then
Me.lblExpectedReturnDate.BackColor = Red
Me.lblExpectedReturnDate.BackColor = Black
But I think I am making a mistake somewhere or I am not putting it in the right place again.
where did you put this code in?
Well I put it in the Form_Load() and in the Form_Open() but both did not work
did you check your labels' backstyle property is set to Normal?
I think I fixed it
Thank you very much. It did not work on the places I placed it before.
Instead I placed it in Form_Current() and changed the code a bit:
If txtExpectedReturnDate <= Date Then
Me.lblExpectedReturnDate.ForeColor = vbRed
Me.lblExpectedReturnDate.ForeColor = vbBlue
Thank you for pointing at my mistakes :-)
well I'm glad I could kinda help. you did figure it out yourself though.