• Assuming that the values for the "Regions" parameter come from a dataset, you can use the count function to get the number of records that are in the dataset and the .COUNT method on the parameter to work out whether all records are still selected.

    I have attached an example using "INFORMATION_SCHEMA.TABLES". It has a couple text boxes showing the counts and the value of the parameter which changes when all values are selected (which is the default).