Parsing names...people...streets...hospitals...is usually one of the biggest hairballs you'll encounter in coding in VBA! The possibilities are simply endless!
You'll also have to taken into account names with commas in it...i.e. Saint Jude's...and periods...V.C.U. Medical Center.
My guess would be that your best approach, going forward, would be to have a Combobox with hospital names. You could have the variations as the first Field...V.C.U. Medical Center...VCU Med Center...MCV (yes...the original name) then the correct name as the second field...Virginia Commonwealth University Medical Center...and have it populate the hospital name field.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007