I have a value list of applicable grade numbers for schools (IE: K, 1, 2, 3) which represent what grades a particular school covers. Previously, I had the grades without the comma separating them but since I have to use this information in a report to an outside agency, I decided to include a comma after each grade number so when it prints in the report, it is clearly distinguishable. Problem is: When I changed the value list to numbers with commas, for some reason the schools appear with both the version without commas and the version with commas in a report. When I look at the record in Browse Mode Form View, the grade levels only appear with the commas but if I look at it in Table view, it shows both versions. First what caused this and last how to fix quickly?
Altering the values in a value list does not alter data previously entered int the field that you format with that value list.
Replace field contents might be used to update your fields so that the needed commas are in place.