I have a form that creates convoy numbers the format should be FC "JulianDate" # of convoy(FC 09 123 01) . I use an afterupdate event to create the field for the julian date and the convoy number is created in a module. the problem is when the convoy number is created the date is fomatted mm/dd/yyyy so the it looks like (FC 05/03/2009 01). I can't figure out how to maintain the formating from the julian date field to the convoynumber field. Any help would be greatly appreciated.