given a table of captions, this sort of logic - but it might be slowish for a lot of captions because of the number of dlookups
Code:form open or load event dim ctrl as control for each ctrl in me.controls if ctrl.controltype = aclabel then 'languagecodes, maybe English=1, german=2 French = 3 newcaption = dlookup("caption" & languagecode,"captiontable","form = " & formname & " label = " & labelname) ctrl.caption =newcaption end if next
If i do this at load form time then max will be about 30 for the more complicated forms. If I do it once for each form at the beginning it will be a few hundred I would think!