TheRadioboy
Registered User.
- Local time
- Today, 22:49
- Joined
- Sep 27, 2017
- Messages
- 20
Hello, please could you help me?
I have a split form and on the datasheet I am trying to format a date column called 'SCHEDULED' (this is the date a specific job will be scheduled for), I have used the expression:-
IsNull(SCHEDULED.Value)
To flag it as a red box if there's no date given, but I'd also like it to display the text 'NOT ASSIGNED'.
Could someone please tell me if it's possible to add that along with the red highlight?
Many thanks!
I have a split form and on the datasheet I am trying to format a date column called 'SCHEDULED' (this is the date a specific job will be scheduled for), I have used the expression:-
IsNull(SCHEDULED.Value)
To flag it as a red box if there's no date given, but I'd also like it to display the text 'NOT ASSIGNED'.
Could someone please tell me if it's possible to add that along with the red highlight?
Many thanks!