What I would like to do is set a fields colour based on the condition of the field, i.e. if the field is empty it shows up in a colour to simplify locating fields which are empty
Set up a conditional format on the field.
You can right click the field while in layout mode to get a menu that lists conditional format as an option.
Use the conditional formatting and create a forumula such as if empty(field) set color(s) to xxx. You can do this for the font color or the background color of the field. I like a light red to indicate that you should put data here...
As you have properly gathered I’m a novice here but you have solved my problem, thank you so much
In addition, for alerting empty there is another feature "placeholder text", this shows red text only if the field is empty.
TextColor ( "empty!!" ; RGB ( 255;0;0 ) )
The Inspector places greyish text into the field if it is empty and you have told it what to do...
Retrieving data ...