When built-in functions stop working it is usually due to a missing reference. Press Ctrl+G to take you to the code window. Click on Tools>References. Check the list for any marked missing. Uncheck them and find the similarly named one that has a
higher version number.
Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals