I'm new to this forum and also to Crystal. I have done a beginners course, but I have encountered a problem that wasn't covered by that course and Googling the problem has not found a solution. I have searched this forum as well and couldn't see it, but I feel sure there must be a simple solution, so I thought I would ask and see if any experts on here can help.

 

I work in Adult Learning, and we have a database of all our students. Unfortunately the people who take our enrolments tend to make a lot of errors in formatting when they type the learner details into the system. I have 3 fields (Title, First Name and Last Name) and I want to get Crystal to search for any that have been typed all in lowercase, or all in uppercase, and highlight those so they can be corrected in the database.

 

Does anyone know if that is possible, and what kind of forumula I would need to use to do it? If anyone is able to help it would be really appreciated, because at the moment the only way we have to spot those errors is to manually check the database, which is massively time-consuming, and always leads to a few being missed.

 

Thanks,

Ben.