Hello,
I wonder if you could help me please. (Please bear in mind I am very new to access and I'm trying my best to learn but I'm not there yet).
I have a form set up and I want to conditional format one field to highlight red. I can do this for one value i.e highlight red when text says 'Undecided Assessment'. But I would like the field to highlight red if the field is 'Undecided Assessment' or 'GB' or 'EU'. Do I need to do this as an expression? I tried setting up three rules and it didn't work?
The other thing I would like to do if possible is using the date of birth work out if a person will be under 18 on the 1st October of each year. So for the data in the current database I would like to know all the people who will be under 18 years old on the 1st October 2020 and highlight them red. Is this possible with conditional formatting? Would this also be an expression?
If possible please can you give me something to cut and paste in! Thank you
I wonder if you could help me please. (Please bear in mind I am very new to access and I'm trying my best to learn but I'm not there yet).
I have a form set up and I want to conditional format one field to highlight red. I can do this for one value i.e highlight red when text says 'Undecided Assessment'. But I would like the field to highlight red if the field is 'Undecided Assessment' or 'GB' or 'EU'. Do I need to do this as an expression? I tried setting up three rules and it didn't work?
The other thing I would like to do if possible is using the date of birth work out if a person will be under 18 on the 1st October of each year. So for the data in the current database I would like to know all the people who will be under 18 years old on the 1st October 2020 and highlight them red. Is this possible with conditional formatting? Would this also be an expression?
If possible please can you give me something to cut and paste in! Thank you