Is it Possible that a label [lblCantEdit] on my form will become visible if [tbDate] is 90 days Old
B Bob Vance Sep 13, 2008 #1 Is it Possible that a label [lblCantEdit] on my form will become visible if [tbDate] is 90 days Old
F fredg Sep 13, 2008 #2 Is it Possible that a label [lblCantEdit] on my form will become visible if [tbDate] is 90 days Old Click to expand... Place the following code in BOTH the form's Current event as well as the [tbDate] control's AfterUpdate event: Me![lblCantEdit].Visible = DateDiff("d",[tbDate],Date()) >= 90
Is it Possible that a label [lblCantEdit] on my form will become visible if [tbDate] is 90 days Old Click to expand... Place the following code in BOTH the form's Current event as well as the [tbDate] control's AfterUpdate event: Me![lblCantEdit].Visible = DateDiff("d",[tbDate],Date()) >= 90
B Bob Vance Sep 13, 2008 #3 Thanks Fred, worked perfectly ...Regards Bob fredg said: Is it Possible that a label [lblCantEdit] on my form will become visible if [tbDate] is 90 days Old Click to expand... Place the following code in BOTH the form's Current event as well as the [tbDate] control's AfterUpdate event: Me![lblCantEdit].Visible = DateDiff("d",[tbDate],Date()) >= 90 Click to expand...
Thanks Fred, worked perfectly ...Regards Bob fredg said: Is it Possible that a label [lblCantEdit] on my form will become visible if [tbDate] is 90 days Old Click to expand... Place the following code in BOTH the form's Current event as well as the [tbDate] control's AfterUpdate event: Me![lblCantEdit].Visible = DateDiff("d",[tbDate],Date()) >= 90 Click to expand...