Search results
-
K
Date field
Hi thanks again with the prompt reply. I have now got the following: If Me![TestDate] <= Now Then Me![TestDate].FontItalic = True Me![TestDate].FontBold = True Me![TestDate].ForeColor = vbRed ElseIf DateDiff("d",Date(),Me![TestDate]) <=30 Then...- kev34
- Post #5
- Forum: Visual Basic
-
K
Date field
Hi many thanks for the quick reply. No problem with orange - I can use vbYellow. However could I ask for a bit more help with the condition? I was thinking something along the lines of: If Me![TestDate] <= Now Then Me![TestDate].FontItalic = True Me![TestDate].FontBold = True...- kev34
- Post #3
- Forum: Visual Basic
-
K
Date field
Hi I have a database that includes a report where the date field changes to red and italic if its overdue. The code is: If Me![TestDate] <= Now Then Me![TestDate].FontItalic = True Me![TestDate].FontBold = True Me![TestDate].ForeColor = vbRed Else...- kev34
- Thread
- Replies: 6
- Forum: Visual Basic
-
K
Cmd Button/Link Doc Help
Hi - I appreciate this thread is old but am hoping you still get this... This is exactly what I need and was wondering if you managed to crack this? Kev